Using JOIN, which of the following MySQL query is almost equivalent to: SELECT…

PYQ EMRS TGT/PGT (ESSE) 2023

Using JOIN, which of the following MySQL query is almost equivalent to: SELECT NAME, MARKS FROM STUDENT, RESULT WHERE STUDENT.ROLL = RESULT.ROLL;

  1. A.

    SELECT NAME, MARKS FROM STUDENT JOIN RESULT;

  2. B.

    SELECT NAME, MARKS FROM STUDENT EQUI JOIN RESULT;

  3. C.

    SELECT NAME, MARKS FROM STUDENT NATURAL JOIN RESULT;

  4. D.

    SELECT NAME, MARKS FROM STUDENT, RESULT;

Attempted by 2260 students.

Sign up free to check your answer

Sign up free

Explore the full course: Emrs Cs Tier 2

Loading lesson…