> > >

Database Management MCQs

Which of the following SOL queries will return the details of only those students who are enrolled in the "Cricket" club?

SELECT Rollno, StudentName FROM StudentDetails WHERE StudentName LIKE (SELECT StudentName FROM StudentDetails WHERE ClubEnrolled = 'Cricket‘);

SELECT Rollno AND StudentName FROM StudentDetails WHERE StudentName IN SELECT StudentName FROM StudentDetails WHERE ClubEnrolled = Cricket;

SELECT Rollno, StudentName FROM StudentDetails WHERE StudentName lN (SELECT StudentName FROM StudentDetails WHERE ClubEnrolled = 'Cricket‘);

SELECT Rollno, StudentName FROM StudentDetails WHERE StudentName lN SELECT StudentName FROM StudentDetails WHERE ClubEnrolled = Cricket

Answer

Correct Answer: SELECT Rollno, StudentName FROM StudentDetails WHERE StudentName lN (SELECT StudentName FROM StudentDetails WHERE ClubEnrolled = 'Cricket‘);

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Database Management Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it