Home / CSE / SQL Basics :: Discussion

Discussion :: SQL Basics

  1. Which of the following query finds the names of the sailors who have reserved at least one boat?

  2. A.

     SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

    B.

     SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

    C.

     SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid;

    D.

     None of These

    View Answer

    Workspace

    Answer : Option A

    Explanation :

    Explanation Not Provided


Be The First To Comment