sql语句排序两个条件:
seq desc
id desc
错误写法
select * from hc_product where flag=1 order by seq,id desc
这种把两个条件连在一起 seq,id desc 写法,会忽略掉前面的seq
正确写法
select * from hc_product where flag=1 order by seq desc,id desc
sql语句排序两个条件:
seq desc
id desc
select * from hc_product where flag=1 order by seq,id desc
这种把两个条件连在一起 seq,id desc 写法,会忽略掉前面的seq
select * from hc_product where flag=1 order by seq desc,id desc