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 |
|
endsabruptly
Starting Member
12 Posts |
 Posted - 2005-04-05 : 09:57:43
|
| I need to select year and lastname from table 1. The trick is that I need year to be desc but the lastname to remain a-z. In other words, I need to list the most recent years first alfa by lastname.any ideas? |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2005-04-05 : 10:01:52
|
| SELECT Year, LastNameFrom MyTableOrder By Year DESC, LastName |
 |
|
|
|
|
|
order by