Thread: Complicated sorting in one sql
View Single Post
  #2 (permalink)  
Old 07-03-2008, 09:02 AM
ben ben is offline
Administrator
  
Join Date: Mar 2007
Posts: 95
ben has disabled reputation
Default ANY answer. Re: Complicated sorting in one sql
I am not 100% sure I understand what you are after but if you want to order the result set by name as well as by Id:

[sql]
Select Id, Test
From Tests
Order by Test, Id
[/sql]
Reply With Quote