关于排序的SQL语句

[ad311500]

我想写一个SQL语句，同时按YEAR排序和按ID序，应该怎么写?

[prefix]

SELECT * FROM YourTable ORDER BY YEAR, ID

[yzdiyu]

select * from tablename
order by year,id

[yzdiyu]

呵呵,又慢了0.5秒

[chenquan]

select * from table order by id,year
i f you

[WWWWA]

SELECT * FROM YourTable ORDER BY YEAR, ID ASC(DESC)

[ad311500]

好，谢谢，晚点结帐

[cdsun]

SELECT * FROM YourTable ORDER BY YEAR, ID DESC


为什么要晚点结账？现在不行？

[gexiaohua0626]

晕,慢了??

[firetoucher]

up一下，过个干瘾：（