sql语句查询结果合并union all用法_数据库技巧
2024-09-01 18:18:11
--合并重复行
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
最新文章
- 移动BPM解决方案分享
- xml读取节点
- 谈谈对BPM的理解
- jQuery基础细节
- console数据
- Android-Universal-Image-Loader
- Java 如何防止线程意外中止
- WPF 视图分组排序
- Flas-SQLAchemy数据库操作使用学习笔记
- SQL Server 查看指定表上的索引
- Django 自定义模版标签和过滤器
- 凸函数与Jensen不等式
- python基础---面向对象的概念
- Tomcat服务相关配置
- CF 1131C Birthday
- sql cast,convert,QUOTENAME,exec 函数学习记录
- js对象深拷贝
- Django 源码小剖: Django 中的 WSGI
- flask 单个表单多个提交按钮
- css样式,高斯模糊