Q:

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

mhmadesk

Save to bookmark

|

2022-07-08

|

480

Medium

0

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

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
SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND COUNT(r1.bid) > r2.bid
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
All 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

(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

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

total answers (1)