select count(distinct a) from (select a from tb union select b from tb) t
select count(distinct a) from (select a from tb union all select b from tb) t
select a,count(distinct a) as 次数 from (select a from tb union all select b from tb) t group by a
count(distinct(A+B)) 如果是数值记得转成字符类型
SELECT COUNT(*) FROM ( SELECT DISTINCT a,b FROM [table] ) tmp
就这个意思,但是好像报错ORA-00937: not a single-group group functionselect F4102.IBLITM,F4102.IBITM,F4102.IBMCU,count(distinct(F41021.LILOCN+F41021.LILOTN)),F41021.* from PRODDTA.F4102 inner join PRODDTA.F41021 on F4102.IBITM=F41021.LIITM and F4102.IBMCU=F41021.LIMCU where F4102.IBVEND='14000'
要加group by的select F4102.IBLITM,F4102.IBITM,F4102.IBMCU,count(distinct(F41021.LILOCN+F41021.LILOTN)),F41021.* from PRODDTA.F4102 inner join PRODDTA.F41021 on F4102.IBITM=F41021.LIITM and F4102.IBMCU=F41021.LIMCU F4102.IBVEND='14000' group by F4102.IBLITM,F4102.IBITM,F4102.IBMCU,F41021.*--把*替换成所有字段
还是报错ORA-01722: invalid numberselect F4102.IBLITM,F4102.IBITM,F4102.IBMCU,count(distinct(F41021.LILOCN+F41021.LILOTN)),F41021.LIPQOH from PRODDTA.F4102 inner join PRODDTA.F41021 on F4102.IBITM=F41021.LIITM and F4102.IBMCU=F41021.LIMCU where F4102.IBVEND='14000' group by F4102.IBLITM,F4102.IBITM,F4102.IBMCU,F41021.LIPQOH
from tb
group by a,b
from
(select a from tb union select b from tb) t
from
(select a from tb union all select b from tb) t
from
(select a from tb union all select b from tb) t
group by a
如果是数值记得转成字符类型
SELECT COUNT(*)
FROM (
SELECT DISTINCT a,b FROM [table]
) tmp
from PRODDTA.F4102 inner join PRODDTA.F41021 on F4102.IBITM=F41021.LIITM and F4102.IBMCU=F41021.LIMCU
where F4102.IBVEND='14000'
from PRODDTA.F4102
inner join PRODDTA.F41021 on F4102.IBITM=F41021.LIITM
and F4102.IBMCU=F41021.LIMCU
F4102.IBVEND='14000'
group by F4102.IBLITM,F4102.IBITM,F4102.IBMCU,F41021.*--把*替换成所有字段
from PRODDTA.F4102 inner join PRODDTA.F41021 on F4102.IBITM=F41021.LIITM and F4102.IBMCU=F41021.LIMCU where F4102.IBVEND='14000'
group by F4102.IBLITM,F4102.IBITM,F4102.IBMCU,F41021.LIPQOH