Discussion :: SQL Basics
- Which of the following query finds the names of the sailors who have reserved at least one boat?
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 |
Answer : Option A
Explanation :
Explanation Not Provided
Be The First To Comment