Multiple choice

Which of the following statements contains an error?

  1. Select * from employee where empid = 505

  2. Select empid from employee where empname = John

  3. Select empid from employee

  4. Select empid where empid = 509 and lname = John

  5. Select * from employee where empid = 305

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

This option is correct because the query does not have 'from' clause which specifies the relation/table from which the values have to be selected.