关于DUAL表与其他表UNION 表GROUP BY的问题
有1张表需要我select da01,
da02,
da03
from dual
我要需要与另外一张表union
select t1.jy da01,
t1.jq da02,
count(distinct decode(t1.js,'Z',t1.jd,null) ) da03
from vw t1
GROUP BY t1.jy, t1.jq
请问该如何写dual表?
select da01,
da02,
da03
from dual
GROUP BY da01,da02
union
select t1.jy da01,
t1.jq da02,
count(distinct decode(t1.js,'Z',t1.jd,null) ) da03
from vw t1
GROUP BY t1.jy, t1.jq
这样不行!新人求助
da02,
da03
from dual
我要需要与另外一张表union
select t1.jy da01,
t1.jq da02,
count(distinct decode(t1.js,'Z',t1.jd,null) ) da03
from vw t1
GROUP BY t1.jy, t1.jq
请问该如何写dual表?
select da01,
da02,
da03
from dual
GROUP BY da01,da02
union
select t1.jy da01,
t1.jq da02,
count(distinct decode(t1.js,'Z',t1.jd,null) ) da03
from vw t1
GROUP BY t1.jy, t1.jq
这样不行!新人求助
...全文
相关推荐
oracle的列转行问题
union all select '数据 2' fid from dual union all select '数据 3' fid from dual ) b;```这个语句使用 decode
oracle—SQL技巧之(二)WMSYS.WM_CONCAT函数实现多行记录用逗号拼接在一起
100UNION ALL SELECT 'B', 'ProductB' || rownum FROM dual CONNECT BY level < 300UNION ALL SELECT 'C', '
Oracle高级sql学习与练习
增强GROUP BY功能,使用GROUP BY扩展选项,如GROUPING SETS、CUBE和ROLLUP等,可以实现更复杂的聚合计算。11.
数据库基础试题及答案
选项D“SELECT所属分类,sum(价格) FROM 产品表 WHERE max(价格) > 1000 GROUP BY 所属分类”是不正确的,因为`MAX()`函数不能在`WHERE`子句中直接使用
oracle常用命令
BY tablespace_name UNION ALL SELECT tablespace_name, SUM(bytes) total FROM dba_temp_files GROUP BY tablespace_name


基础和管理
