多问一句,我怎么控制id=5的信息第一条显示呢,因为order=7的有可能会有多条数据再加个按id排序呢,5比较小能排前面些,但是不能保证一定id=5的排在第一条 select * from A where A.order<=7 order by A.order desc,A.id如果一定要把id=5的那条数据排在第一条就这样试试吧: select * from A where A.id=5 order union all select * from A where A.order<=7 and A.id!=5 order by A.order desc
select * from A where A.order<=7 order by A.order desc,A.id如果一定要把id=5的那条数据排在第一条就这样试试吧:
select * from A where A.id=5 order
union all
select * from A where A.order<=7 and A.id!=5 order by A.order desc