select * from user where 1=1 order by salary*1 desc limit 0,5
or
select * from user where 1=1 order by salary+0 desc limit 0,5
select * from user where 1=1 order by salary*1 desc limit 0,5
or
select * from user where 1=1 order by salary+0 desc limit 0,5
转载于:https://www.cnblogs.com/fpcbk/p/9875764.html