Sams Teach Yourself SQL in 24 Hours, Second Edition

Hour 10, "Sorting and Grouping Data"

Quiz Answers

1:

Will the following SQL statements work? SELECT SUM(SALARY), EMP_ID FROM EMPLOYEE_PAY_TBL GROUP BY 1 and 2; SELECT EMP_ID, MAX(SALARY) FROM EMPLOYEE_PAY_TBL GROUP BY SALARY, EMP_ID; SELECT EMP_ID, COUNT(SALARY) FROM EMPLOYEE_PAY_TBL ORDER BY EMP_ID GROUP BY SALARY;

A1:

No, this statement does not work. The and in the GROUP BY clause does not belong there, and you cannot use an integer in the GROUP BY clause. The correct syntax is SELECT SUM(SALARY), EMP_ID FROM EMPLOYEE_PAY_TBL GROUP BY SALARY, EMP_ID; Yes, this statement will work. No, this statement will not work. The ORDER BY clause and the GROUP BY clause are not in the correct sequence. Also, the EMP_ID column is required in the GROUP ...