SQL Server: The Magical OVER clause (connectsql.blogspot.com)

submitted by lionofdezertlionofdezert(1110) 1 year, 2 months ago

When comes to query writing, I think, I am so lazy ;) and always prefer less code. Recently I found OVER clause so helpful to write my code in more effect and more magical way.

1 comment |category: |Views: 26

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
Comments:

posted by spoulsonspoulson(327) 1 year, 2 months ago 0

The article really should explain the OVER clause or reference other material. Some example query results would've been ideal.

Reply

information Login or create an account to comment on this story