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.
B) To return the names of students with the highest age.
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