先用子查询各自查询好所需要的数据,然后各自排序好再合并,在子查询中加入limit或聚合函数,能使排序生效.
select * from
(select data from data_table where type =1 order by data desc limit 0,1000)a1
union
select * from
(select deat from data_table where type =0 order by data asc limit 0,1000)a2
先用子查询各自查询好所需要的数据,然后各自排序好再合并,在子查询中加入limit或聚合函数,能使排序生效.
select * from
(select data from data_table where type =1 order by data desc limit 0,1000)a1
union
select * from
(select deat from data_table where type =0 order by data asc limit 0,1000)a2