Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-11 : 23:17:55
|
Tonya of S. Florida writes "I'm using SQL Server 7.0. I have duplicate records in a table
and can display the distinct records by using:
"Select distinct * from dogs order by weight"
This is good except that the breed of dog appears in random order.
I would like to display the distinct records based on the first
query and sort these records by breed.
I have tried the following statement:
"Select distinct * from dogs order by weight, breed"
This does not work. I look forward to your help." |
|
|
|
|
|
Sort Query Result