union 用于合并结果集,并消去表中任何重复行。
unionall 不消除重复行
union order by 同时用 (select * from A where name="" ) union ( select * from A where id="") order by age
若要对单独进行排序
必须要和limit同时使用
(select * from A where name="" order by age limit 10) union ( select * from A where id="" order by id limit 10)