Question

Identify the errors in the following SQL statement and give reason for the error. 

SELECT FROM STUDENT 

ORDER BY Group 

WHERE Marks above 50;

Answer 1

In this query Group is the key word hence it cannot be used.

 The correct query is as follows. 

SELECT * FROM STUDENT WHERE Marks > 50 ORDER BY Marks;