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 |
|
subhaoviya
Posting Yak Master
135 Posts |
 Posted - 2011-12-05 : 02:10:53
|
| Hi, having table TableA with columns Col1, col2, col3, col4. i need to produce the resultset by sorting the col1 in asc, then with col2 in desc and with col3 in asc. how to implement this three column sorting in single query.thankssubha |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-12-05 : 02:14:31
|
[code]ORDER BY col1 ASC, col2 DESC, col3 ASC[/code]
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
column sorting in resultset.