ExamCompetition Your Success, Our Mission
Login Register
Question discussion

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

319176Medium 1 reply 673 views
0
Which of the following query finds the names of the sailors who have reserved at least one boat?
  • ASELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;
  • BSELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;
  • CSELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid;
  • DNone of These
Correct answer: A
Join the discussion Report an error

Discussion 1

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