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-11-16 : 09:39:20
|
| Al writes "I've got a table which contains results. One field in each record describes the position the person came in the competition, but it can also contain a 0 indicating they didn't finish the race.How do I sort the data such that the results are ordered by ascending result, but with the 0 records at the end??ie.Fred 1John 2Bill 3James 0Bob 0thanks,alSql Server 7, NT platform." |
|
|
|
|
|
Order by ascending, but without 0 rows