單項(xiàng)選擇題
查看下面的部分語句:SELECTename,sal,commFROMemp;現(xiàn)在查看以下輸出:ENAMESALCOMM-----------------------------------------MARTIN12501400WARD1250500ALLEN1600300TURNER15000ADAMS1100BLAKE2850CLARK2450FORD3000JAMES950JONES2975KING5000MILLER1300SCOTT3000SMITH800哪條ORDERBY子句將生成所顯示的輸出()
A.ORDERBYcommDESCNULLSLAST,ename
B.ORDERBYNVL(comm,0)ASCNULLSLAST,ename
C.ORDERBYNVL(comm,0)ASCNULLSFIRST,ename
D.ORDERBYNVL(comm,0)DESC,ename
A.ORDERBYcommDESCNULLSLAST,ename
B.ORDERBYNVL(comm,0)ASCNULLSLAST,ename
C.ORDERBYNVL(comm,0)ASCNULLSFIRST,ename
D.ORDERBYNVL(comm,0)DESC,ename