排序:
我想先将记录先按照last_time由大到小排序,在last_time值相同的条件下按照id值由大到小排列,以保证晚发布的信息有优先的露面的机会,请问这个sql语句应该如何写?
order by last_time desc ,id desc
select * from (select * from tablename order by last_time desc) as t order by t.id desc
排序:
我想先将记录先按照last_time由大到小排序,在last_time值相同的条件下按照id值由大到小排列,以保证晚发布的信息有优先的露面的机会,请问这个sql语句应该如何写?
order by last_time desc ,id desc
select * from (select * from tablename order by last_time desc) as t order by t.id desc