Oracle
如何将下面二个SQL合并？
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区 ---语句一
SELECT MIN(NSRSBH)
INTO START_WSPZH
FROM (SELECT NSRSBH
FROM (SELECT TT1.NSRSBH, ROWNUM ROWNO
FROM (SELECT T.NSRSBH
FROM WORK_INFO_MAIN M, WORK_INFO_CHILD T, DJ_NSRXX D
WHERE M.SERIAL_NO = T.SERIAL_NO
AND T.NSRSBH = D.NSRSBH
AND T.YXZT_DM = '3'
AND (T.LSSJ = 0 OR T.LSSJ IS NULL)
AND D.CGS_FLAG = 1
AND M.CZRY_DM = C_USER.USER_ID
ORDER BY TJRQ
) TT1)
WHERE ROWNO BETWEEN START_NUM AND END_NUM);
---语句二
SELECT MAX(NSRSBH)
INTO END_WSPZH
FROM (SELECT NSRSBH
FROM (SELECT TT1.NSRSBH, ROWNUM ROWNO
FROM (SELECT T.NSRSBH
FROM WORK_INFO_MAIN M, WORK_INFO_CHILD T, DJ_NSRXX D
WHERE M.SERIAL_NO = T.SERIAL_NO
AND T.NSRSBH = D.NSRSBH
AND T.YXZT_DM = '3'
AND (T.LSSJ = 0 OR T.LSSJ IS NULL)
AND D.CGS_FLAG = 1
AND M.CZRY_DM = C_USER.USER_ID
ORDER BY TJRQ
) TT1)
WHERE ROWNO BETWEEN START_NUM AND END_NUM);
SELECT MIN(NSRSBH)
INTO START_WSPZH
FROM (SELECT NSRSBH
FROM (SELECT TT1.NSRSBH, ROWNUM ROWNO
FROM (SELECT T.NSRSBH
FROM WORK_INFO_MAIN M, WORK_INFO_CHILD T, DJ_NSRXX D
WHERE M.SERIAL_NO = T.SERIAL_NO
AND T.NSRSBH = D.NSRSBH
AND T.YXZT_DM = '3'
AND (T.LSSJ = 0 OR T.LSSJ IS NULL)
AND D.CGS_FLAG = 1
AND M.CZRY_DM = C_USER.USER_ID
ORDER BY TJRQ
) TT1)
WHERE ROWNO BETWEEN START_NUM AND END_NUM);
---语句二
SELECT MAX(NSRSBH)
INTO END_WSPZH
FROM (SELECT NSRSBH
FROM (SELECT TT1.NSRSBH, ROWNUM ROWNO
FROM (SELECT T.NSRSBH
FROM WORK_INFO_MAIN M, WORK_INFO_CHILD T, DJ_NSRXX D
WHERE M.SERIAL_NO = T.SERIAL_NO
AND T.NSRSBH = D.NSRSBH
AND T.YXZT_DM = '3'
AND (T.LSSJ = 0 OR T.LSSJ IS NULL)
AND D.CGS_FLAG = 1
AND M.CZRY_DM = C_USER.USER_ID
ORDER BY TJRQ
) TT1)
WHERE ROWNO BETWEEN START_NUM AND END_NUM);
...全文
相关推荐
SQL合并一列
可将分组后的一列值合并为一个字段，经常用于一些会计科目的显示
SQL 列不同的表查询结果合并操作
两个不同的表进行查询，需要把结果合并， 比如table1的列为 id, user_id, type_id,pro_id； table2的列为 id,user_id,collect_id；分别如下图所示 table1： table2： 将两个表的查询结果合并到一起的查询语句为 select *, null as collect_id from table1 where user_id = 527 union select id,user_id,null as type_id,null as pro_id, collect_id from table2 where user_id = 527
sql实现多行合并一行
可以实现多行查询数据转换到一行上显示，多行的某列信息用“，”号隔开。
合并SQL小工具 多个SQL文件合并
可以合并多个SQL文件，一般用于生产前数据合并 可选择文件夹进行合并
sql 多行合并某一列字符串拼接的示例
sql 多行合并某一列字符串拼接的示例语句
