按id升序和name降序来排 select id,name from table order by id,name desc
按id升序和name降序来排 select id,name from table order by id asc ,name desc
select ID,name from tablename order by ID Asc ,name Desc
--要看哪一个优先了 create table #test ( id char(3), name char(10) ) insert into #test select '1' , 'steven' union select '2' , 'tom' union select '3' , 'abc' union select '4' , 'zyx' select * from #test order by id asc,name descid name ---- ---------- 1 steven 2 tom 3 abc 4 zyx (4 row(s) affected)select * from #test order by name desc, id ascid name ---- ---------- 4 zyx 2 tom 1 steven 3 abc (4 row(s) affected)--drop table #test
select ID,name from tablename order by ID Asc ,name Desc
select * from MY_table order by ID {Asc / Desc}, INDEX {Asc / Desc}
select id,name from table order by id,name desc
select id,name from table order by id asc ,name desc
create table #test
(
id char(3),
name char(10)
)
insert into #test
select '1' , 'steven'
union select '2' , 'tom'
union select '3' , 'abc'
union select '4' , 'zyx'
select * from #test order by id asc,name descid name
---- ----------
1 steven
2 tom
3 abc
4 zyx (4 row(s) affected)select * from #test order by name desc, id ascid name
---- ----------
4 zyx
2 tom
1 steven
3 abc (4 row(s) affected)--drop table #test