17,377
社区成员
发帖
与我相关
我的任务
分享
SQL> select count(distinct deptno) from scott.emp;
COUNT(DISTINCTDEPTNO)
---------------------
3
SQL>
with a as (select distinct box from table1 )
select count(*) from a
-- 估计是:人品问题!
scott@TBWORA> select count(distinct deptno) from emp;
COUNT(DISTINCTDEPTNO)
---------------------
3