Consider a database table R with attributes A and B. Which of the following…

Consider a database table R with attributes A and B. Which of the following SQL queries is illegal ?

  1. A.

    SELECT A FROM R;

  2. B.

    SELECT A, COUNT(*) FROM R;

  3. C.

    SELECT A, COUNT(*) FROM R GROUP BY A;

  4. D.

    SELECT A, B, COUNT(*) FROM R GROUP BY A, B;

Attempted by 816 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…