Q. What is the result of the following SQL statement?
SELECT MAX(EXAM_SCORE) FROM EXAM_RESULTS GROUP BY EXAM_ID HAVING EXAM ID = 1 ;
(a) 90
(b) 85
(c) 100
(d) 95
Consider this table --
You can understand by seeing this video ---
Answer =
(d) 95
Consider this table --
You can understand by seeing this video ---
wrong question because "HAVING EXAM ID = 1" , exam id doesnt exist in the table, "EXAM_ID" exists
ReplyDeletePost a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )