Main use is to order the rows. The standard behavior of a sql select query is to not return rows in a set order without an order by clause.
A secondary use is with the Top key word. It defines what the first rows are
If using windowing functions they define how the window is drawn. What is the first row in the window, what is the last row, what is the previous, next row.
Russel Loski, MCT, MCSE Data Platform/Business Intelligence. Twitter: @sqlmovers; blog: www.sqlmovers.com
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?