what is the use of Over Clause

• sej2008

  SSCarpal Tunnel

  Points: 4495

  More actions

  December 9, 2013 at 6:33 am

  #279774

  I would like to know when and how to use over clause in sql 20012 with proper example.

• BrainDonor

  SSCoach

  Points: 19259

  More actions

  December 9, 2013 at 6:50 am

  #1671919

  There are several very good examples in Technet: http://technet.microsoft.com/en-us/library/ms189461.aspx

  Another example, using it within Row_Number: http://sqlrambling.net/2013/11/04/row_number-basic-example/

  Steve Hall
  Linkedin
  Blog Site

• Alan Burstein

  SSC Guru

  Points: 61141

  More actions

  December 9, 2013 at 12:10 pm

  #1672092

  Here's a good article by Robert Sheldon with some examples:

  Working with Window Functions in SQL Server[/url]

  "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

  -- Itzik Ben-Gan 2001

• Alan Burstein

  SSC Guru

  Points: 61141

  More actions

  December 13, 2013 at 10:25 am

  #1673345

  Duh... Here's a few more :hehe:

  http://www.sqlservercentral.com/Forums/Topic1519856-824-29.aspx#bm1522006

  "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

  -- Itzik Ben-Gan 2001