view plaincopy to clipboardprint?
--合并重复行  
select * from A  
union   
select * from B   
 
--不合并重复行  
select * from A  
union all  
select * from B     
 
按某个字段排序  
--合并重复行  
select *  
from (  
select * from A  
union   
select * from B) AS T  
order by 字段名  
 
--不合并重复行  
select *  
from (  
select * from A  
union all  
select * from B) AS T  
order by 字段名  
 
//sql server版  
Select * From (  
select top 2 id,adddate,title,url from bArticle where ClassId=1 order by adddate desc) A  
Union All  
Select * From (  
select top 2 id,adddate,title,url from bArticle where ClassId=2 order by adddate desc) B  
Union All  
Select * From (  
select top 2 id,adddate,title,url from bArticle where ClassId=3 order by adddate desc) C  
Union All  
Select * From (  
select top 2 id,adddate,title,url from bArticle where ClassId=4 order by adddate desc) D   
 
//mysql版  
Select * From (  
select id,adddate,title,url from bArticle where ClassId=1 order by adddate desc limit 0,2) A  
Union All  
Select * From (  
select id,adddate,title,url from bArticle where ClassId=2 order by adddate desc limit 0,2) B  
Union All  
Select * From (  
select id,adddate,title,url from bArticle where ClassId=3 order by adddate desc limit 0,2) C  
Union All  
Select * From (  
select id,adddate,title,url from bArticle where ClassId=4 order by adddate desc limit 0,2)
    希望这篇sql语句查询结果合并union all用法_数据库技巧的文章能够对您有所帮助，如果您觉得这篇网站维护教程有用的话，别忘了推荐给您的朋友哦！如果您有好的经验方法，不妨拿出来和大家一起分享：假如每个人都拿出一个经验，那么我们都将额外的获取一堆他人的经验。
请记住本站永久域名：（黑客防线网安服务器维护方案维护基地）Www.Rongsen.Com.Cn