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 |
|
dcarva
Posting Yak Master
140 Posts |
 Posted - 2004-05-22 : 10:00:38
|
| Hello,I am trying to sort on two columns in descending order. Both fields are ints in SQL Server.SELECT *FROM Table1ORDER BY Test1, Test2 DESCI can only sort ascending. It won't sort descending. Any suggestions? Can this be done?Thanks,Danny |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-05-22 : 10:19:59
|
Do you mean, perhaps:ORDER BY Test1 DESC, Test2 DESC Kristen |
 |
|
|
dcarva
Posting Yak Master
140 Posts |
Posted - 2004-05-22 : 13:09:12
|
| Yes! That's exactly it. I should have thought of that! Thanks! |
|
|
|
|
|
|
Sorting