请教：想先按id排序再按code排序应该怎么写？select * from database order by id order by code不行???

[bibibi]

请教：想先按id排序再按code排序应该怎么写？select * from database order by id order by code不行???

[ring]

select * from database order by id , code

[ring]

select * from database order by id , code

[eaglet]

如果是mssql 数据库用ring 的方法
也可以写为
select * from database order by 1,2
假设 id 为第一个字段，code为第二个字段

其他数据库ring的方法有时不好用，我的这个方法
有时好用.

[jjdelphi]

select * from id,code

[iStringTheory]

你的语法错误。
你可以使用Select * from database order by id ,code

[落入凡间的猪]

select * from database order by id , code

[xiaming]

select * from database order by id , code