Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

White space Expand / Collapse
Author
Message
Posted Sunday, July 21, 2013 7:02 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 18, 2013 9:09 PM
Points: 16, Visits: 28
I heard TSQL defaulted in SELECT DISTINCT queries to sorting by ASC. The ORDER BY worked.

My next problem will be to order by the number of entries in columns.

I'm enjoying learning SQL.
Post #1475848
Posted Monday, July 22, 2013 1:28 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, December 12, 2014 1:02 AM
Points: 823, Visits: 753
mikej 14403 (7/21/2013)
I heard TSQL defaulted in SELECT DISTINCT queries to sorting by ASC.


Whenever you hear such things turn a deaf ear to it. The only way to get a guaranteed order from a SELECT statement is to add an ORDER BY.


Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1475885
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse