Which of the following is using wrong syntax for a SELECT query in SQL?

PYQ KVS TGT/PGT 2023

Which of the following is using wrong syntax for a SELECT query in SQL?

  1. A.

    SELECT * WHERE RNO>100 FROM STUDENT;

  2. B.

    SELECT * FROM STUDENT WHERE RNO>100;

  3. C.

    SELECT * FROM STUDENT WHERE RNO BETWEEN 100 AND 200;

  4. D.

    SELECT * FROM STUDENT WHERE RNO IN (100, 101, 105, 104);

Attempted by 1821 students.

Sign up free to check your answer

Sign up free

Explore the full course: Kvs Nvs Tier 2 Computer Science

Loading lesson…