Q:

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

mhmadesk

Save to bookmark

|

2022-07-08

|

456

Medium

0

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

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

Database, MCQ Questions, Database MCQ-questions,

login and add your own answer to this question

All Answers

mhmadesk

2022-07-08

need an explanation for this answer? contact us directly to get an explanation for this answer

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

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)