Menu
Home / CSE / SQL Basics :: Discussion

Discussion :: SQL Basics

  1. Which of the following query finds the name of the sailors who have reserved at least two boats?

    2. A.

     SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid ≠ r2.bid
    B.

     SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND COUNT(r1.bid) > r2.bid
    C.

     SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid <> r2.bid
    D.

     All of these

    View Answer

    Workspace

    View Answer

    Answer : Option C

    Explanation :

    Explanation Not Provided

Write your comments here:

Be The First To Comment