关于DUAL表与其他表UNION 表GROUP BY的问题

dctg2003 2010-07-27 03:54:07

有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
这样不行！新人求助

...全文

137 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

beita258 2010-07-27

打赏
举报

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楼

minitoy 2010-07-27

打赏
举报

类型转换下就可以了

minitoy 2010-07-27

打赏
举报

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>

dctg2003 2010-07-27

打赏
举报

查询模块有不正确的结果数列。dual表要全是空的。。

cyousor 2010-07-27

打赏
举报



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