Multiple choice

Which of the following SQL query is the example of equi join?

  1. SELECT first_name, last_name, subject FROM student_details WHERE subject = 'Economics'

  2. SELECT first_name, last_name, subject FROM student_details WHERE marks>90

  3. SELECT first_name, last_name, subject FROM student_details WHERE marks=>90

  4. Both (1) and (3)

  5. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

This is example of equi-join as it has equal operator.

Keep practicing — related questions