what is the use of Over Clause

Question

Post reply

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.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

BrainDonor SSCoach Points: 19256 More actions · Answer 1

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 · Answer 2

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 · Answer 3

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