A. SELECTename,salsalaryFROMempORDERBYsal; B. SELECTename,salsalaryFROMempORDERBYsalary; C. SELECTename,salsalaryFROMempORDERBY3; D. SELECTenameFROMempORDERBYsalDESC;
A. SELECTdeptno,sum(sal)FROMemp; B. SELECTdeptno,sum(sal)FROMempWHEREavg(sal)>2000GROUPBYdeptno; C. SELECTdeptno,sum(sal)FROMempGROUPBYdeptnoHAVINGavg(sal)>2000; D. SELECTdeptno,sum(sal)FROMempWHEREavg(sal)>2000ORDERBYdeptno;