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-09-10 : 18:01:09
|
| Brent writes "I have a small communications website (http://62.254.5.149). It is nothing special, it's just to see if I have the knowledge (obviously not if I'm asking you a question).I have an inbox and I want the new messages to appear at the top. But because the SQL statement 'ORDER BY ID', orders and displays them from smallest ID number to largest ID number. This would make anynew messages appear at the bottom.So is there a way to make the SQL statement or by largest number down to the smallest number???Thank you for your time,Brent NewburyI am running an Access Database on a Windows 2000 server (with IIS 5.0)" |
|
|
|
|
|
Order By Largest Number First