SQL Server sql 查询结果合并union all用法
2022-11-12 09:54:01
内容摘要
这篇文章主要为大家详细介绍了SQL Server sql 查询结果合并union all用法,具有一定的参考价值,可以用来参考一下。
对此感兴趣的朋友,看看idc笔记做的技术笔记!
代码如下:
--
文章正文
这篇文章主要为大家详细介绍了SQL Server sql 查询结果合并union all用法,具有一定的参考价值,可以用来参考一下。
对此感兴趣的朋友,看看idc笔记做的技术笔记!
代码如下:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 | <code>--合并重复行 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) D </code> |
注:关于SQL Server sql 查询结果合并union all用法的内容就先介绍到这里,更多相关文章的可以留意
代码注释