This question is based on the following SQL table MYSTUDENT: ROLLNO NAME SEC…

Navodaya Vidyalaya Samiti 2022

This question is based on the following SQL table MYSTUDENT:

ROLLNO    NAME       SEC    MARKS
80105     MARIA      A      83.0
80108     AMAR       B      44.0
80109     MANPREET   A      92.0
80112     SAMEER     A      81.0
80115     AKBAR      B      NULL

Which SQL command can be used to display each distinct SEC value from MYSTUDENT?

  1. A.

    SELECT DISTINCT SEC FROM MYSTUDENT;

  2. B.

    SELECT DIFFERENT SEC FROM MYSTUDENT;

  3. C.

    SELECT ALL SEC FROM MYSTUDENT;

  4. D.

    SELECT UNIQUE SEC FROM MYSTUDENT;

Attempted by 2574 students.

Sign up free to check your answer

Sign up free

Explore the full course: Bpsc

Loading lesson…