Database contains the relation course (Id, name, semester, year), which of the…

MH-SET 2020

Database contains the relation course (Id, name, semester, year), which of the following is an incorrect SQL query ?

  1. A.

    Select * from course order by year;

  2. B.

    Select count(semester), semester from course group by semester;

  3. C.

    Select semester from course group by semester where count (semester) > z;

  4. D.

    Select count (semester), semester from course group by semester order by count (semester);

Attempted by 15 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…