关于DUAL表与其他表UNION 表GROUP BY的问题 本帖最后由 dctg2003 于 2010-07-27 15:54:52 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 简单来说就是dual表与 带GROUP BY 的表union select 'da01' da01, 'da02' da02, 'da03' da03 from dualunionselect 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表要全是空的。。 SQL> SQL> select 'da01' da01, 'da02' da02, 'da03' da03 2 from dual 3 union 4 select t1.jy da01, 5 t1.jq da02, 6 to_char(count(distinct decode(t1.js, 'Z', t1.jd, null))) da03 7 from vw t1 8 GROUP BY t1.jy, t1.jq 9 ; DA01 DA02 DA03---------- ---------- ----------------------------------------da01 da02 da03 SQL> union union all 数据类型应该一致吧楼主 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与 select dual union 时须匹配,类似与3楼 OracleOraDb11g_home1TNSListener启不起来 求一个Sql -- 写一个创建相关表的SELECT 语句(排除指定字段)的代码给那些懒鬼们 -- 插入时用来检测记录是否存在的Oracle存储过程 varchar2 转 bolb 取表名的问题,在线等!!!急!!!! 求一UPDATE语句,从一表向另一表中更新内容 如何启动服务:Oracle Management Server? 怎样导入含有加密存储过程包的备份文件? 在ORACLE数据库中,怎么insert不同用户下的所有表 ORACLE的相关问题 创建表空间为什么使用的时候报错呢
select 'da01' da01, 'da02' da02, 'da03' 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
SQL> select 'da01' da01, 'da02' da02, 'da03' da03
2 from dual
3 union
4 select t1.jy da01,
5 t1.jq da02,
6 to_char(count(distinct decode(t1.js, 'Z', t1.jd, null))) da03
7 from vw t1
8 GROUP BY t1.jy, t1.jq
9 ;
DA01 DA02 DA03
---------- ---------- ----------------------------------------
da01 da02 da03
SQL>
union all 数据类型应该一致吧楼主
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
与 select dual union 时须匹配,类似与3楼