Which of the following lines of the SQL statement contains an error?
1 SELECT title,MAX(retail)
2 FROM books
3 WHERE retail 30
4 AND pubid = 1
5 GROUP BY retail
A) Line 2
B) Line 3
C) Line 4
D) Line 5

Question

Which of the following lines of the SQL statement contains an error?
1 SELECT title,MAX(retail)
2 FROM books
3 WHERE retail > 30
4 AND pubid = 1
5 GROUP BY retail
A) ​Line 2
B) ​Line 3
C) ​Line 4
D) ​Line 5

Quizplus · Accepted Answer

GROUP BY should only include columns that are being selected or aggregated. In this case, "retail" is being grouped by but it is not part of the SELECT statement or being aggregated. This will result in an error.

Which of the Following Lines of the SQL Statement Contains