Which of the following operators cannot be used with distinct?
A.MAX
B.COUNT
C.all of the above
D.MIN
做了一个实验如下,发现这些都可以和distinct一起使用,所以这个题没有答案。
SQL> select distinct count(empno) from emp;
COUNT(EMPNO)
------------
14
SQL> select count(distinct empno) from emp;
COUNT(DISTINCTEMPNO)
--------------------
14
SQL> select distinct max(empno) from emp;
MAX(EMPNO)
----------
7934
SQL> select distinct min(empno) from emp;
MIN(EMPNO)
----------
7369