Question
Answered

What query produces the same results as the one below? SELECT...

What query produces the same results as the one below?

SELECT Student.StdNo, Student.StdFirstName, Student.StdLastName, Student.StdMajor

FROM Student

WHERE EXISTS(SELECT * FROM Enrollment WHERE Enrollment.StdNo = Student.StdNo)


possible answers

a. SELECT Student.StdNo, Student.StdFirstName, Student.StdLastName, Student.StdMajor

FROM Student, Enrollment

WHERE Enrollment.StdNo = Student.StdNo

b. SELECT Student.StdNo, Student.StdFirstName, Student.StdLastName, Student.StdMajor

FROM Student

WHERE StdNo IN(SELECT DISTINCT StdNo FROM Enrollment)

c. SELECT Student.StdNo, Student.StdFirstName, Student.StdLastName, Student.StdMajor

FROM Student

LEFT OUTER JOIN Enrollment ON Enrollment.StdNo = Student.StdNo

WHERE Enrollment.StdNo IS NOT NULL

D. All of the above

Answer & Explanation
Verified Solved by verified expert

s ante, dapib

ce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum

ec facilisis

entesque dapibus efficitur laoreet. Nam risus ante,

m ipsum dolor

Unlock full access to Course Hero

Explore over 16 million step-by-step answers from our library

Subscribe to view answer
Student reviews
78% (9 ratings)