You are not logged in.

#1 2015-09-18 06:23:35

hasnain
Administrator
From: Chichawatni
Registered: 2014-10-13
Posts: 8,355
Website

SQL Query Finds:

http://interviewquestionsanswers.org/quiz/Database http://interviewquestionsanswers.org/qu … L-Database

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;


Failure is the first step towards seccess.

2015-09-18 06:23:35

Advertisement
Ads By Google

Re: SQL Query Finds:



Board footer