You are not logged in.
Pages:: 1
#1 2015-09-18 06:23:32
SQL Query Finds:
Database Quizzes SQL
Question:
Which of the following query finds the names of the sailors who have reserved at least one boat?
Option A):
SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;
Option B):
SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;
Option C):
SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid;
Correct Answer is Option B):
SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;
You cannot discover the new oceans unless you have the courage to lose the sight of the shore.
Offline
2015-09-18 06:23:32
- Advertisement
- Ads By Google
Re: SQL Query Finds:
\n
Pages:: 1