三个select联合查询,查询结果先以第一个表的字段排序,再以第二个表的字段排序,最后以第三个表的字段排序,怎么写啊
解决方案 »
- 求SQL语句?
- 请教各位前辈,关于SQL SERVER里处理字符串的问题
- 急求解(SQl-循环-输入-作业)
- 请教一个SQL语句(update)
- 这里为什么不能加括号?
- SQL语句查当前进程数,登录服务器和以Web方式查询返回的相差很远?
- 编译 libpqxx出错 正在创建库 lib\libpqxxD.lib 和对象 lib\libpqxxD.exp
- 触发器问题,两个表,在表a中插入记录或者更新记录时,表b只更新时间最大的记录
- 我现在碰到一个问题:数据库在服务器上,我要在本地机器查数据库的数据,而且 是经常性的,固定内容的查询,用什么办法呢
- 关于asp 和 sql server的问题
- 如何把union 得到的结果放到临时表中去
- 关于 VARIANT_TRUE的一点疑问?
order by a.字段,b.字段,c.字段
union all select a ,2 as b from tb_b
union all select a ,3 as b from tb_corder by b asc
(
select a.SubmitInfoRID
from t_event_submitInfo t
left join t_event_submitOppose a on t.rid=a.SubmitInfoRID
left join t_base_dept b on a.subopposerRID=b.rid
union ALL
select a.SubmitInfoRID
from t_event_submitInfo t
left join t_event_submitOppose a on t.rid=a.SubmitInfoRID
left join t_base_outdept c on a.subopposerRID=c.rid
union ALL
select a.SubmitInfoRID
from t_event_submitInfo t
left join t_event_submitOppose a on t.rid=a.SubmitInfoRID
left join t_base_watchfix d on a.subopposerRID=d.rid
) as SubmitOpposer分别以t_base_dept,t_base_outdept,t_base_watchfix相同的sequence排序,要怎么排?
(
select a.SubmitInfoRID ,1 as woyaomm
from t_event_submitInfo t
left join t_event_submitOppose a on t.rid=a.SubmitInfoRID
left join t_base_dept b on a.subopposerRID=b.rid
union ALL
select a.SubmitInfoRID ,2 as woyaomm
from t_event_submitInfo t
left join t_event_submitOppose a on t.rid=a.SubmitInfoRID
left join t_base_outdept c on a.subopposerRID=c.rid
union ALL
select a.SubmitInfoRID ,3 as woyaomm
from t_event_submitInfo t
left join t_event_submitOppose a on t.rid=a.SubmitInfoRID
left join t_base_watchfix d on a.subopposerRID=d.rid
) as SubmitOpposer
order by woyaomm ,SubmitInfoRID