What is the purpose of the subquery

Tuhin Paul

3y1.4k.NET

What is the purpose of the subquery in the following query?
SELECT Name FROM Students WHERE Age = (SELECT MAX(Age) FROM Students)
A) To return all the students’ names.
B) To return the names of students with the highest age.
C) To return the names of students with the lowest age.

2 Answers

B) To return the names of students with the highest age.

NARASIMMAN PERUMAL3y

If we want to filter the record based on the selection of the record of another table then we can use subquery. First subquery will executed and whatever result we get it will filter data from main query

Alpesh Maniya3y