SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag order by Rss

Search for any content tagged order by

   Items 1 to 4 of 4   
 

Finding code smells using SQL Prompt: TOP without ORDER BY in a SELECT statement

SQL Server’s TOP clause in a SELECT statement is very useful and intuitive, but it allows you to leave out the associated ORDER BY clause that clarifies what you had in mind: TOP by what aspect? Phil Factor explains how to find code smells using SQL Prompt: TOP without ORDER BY in a SELECT statement   Read more...
By 2018/05/28 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 3,066 reads

Implementing a custom sort

Rob Farley discusses some solutions and gotchas for implementing a custom sort using ORDER BY in T-SQL queries.  Read more...
By Additional Articles 2016/11/21 | Source: SQLPerformance.com | Category: order by
Rating:  Rate this |   Briefcase | 3,512 reads

Returning Sorted Record Sets Using the ORDER BY Clause

Having your data returned to you in some meaningful sorted order is important sometimes. If you don’t tell SQL Server you want to order the results of a SELECT statement then there is no guarantee that your result set will come back in a particular order. To make sure a result set is ordered you need to use the ORDER BY clause. In this article I will be exploring how to return an order result set by using the ORDER BY clause.  Read more...
By Additional Articles 2015/01/16 | Source: Database Journal | Category: order by
Rating: (not yet rated)  Rate this |   Briefcase | 10,240 reads

Stairway to T-SQL DML Level 6: The Basics of Sorting Data Using the ORDER BY Clause

In this Level you will see how to use the ORDER BY clause to return your data in a sorted order.  Read more...
By Gregory Larsen 2011/12/14 | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,610 reads
   Items 1 to 4 of 4