Tuhin Paul
What is the purpose of the subquery

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.

By Tuhin Paul in .NET on Apr 15 2023
  • NARASIMMAN PERUMAL
    May, 2023 26

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

    • 0
  • Alpesh Maniya
    May, 2023 11

    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

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS