Find name and age of the oldest sailor(s)

• The first query is illegal! (We’ll look into the reason a bit later, when we discuss GROUP BY.)

• The third query is equivalent to the second query, and is allowed in the SQL/92 standard, but is not supported in some systems.

SELECT S.sname, MAX (S.age)

FROM Sailors S

SELECT S.sname, S.age

FROM Sailors S

WHERE S.age =

(SELECT MAX (S2.age)

FROM Sailors S2)

SELECT S.sname, S.age

FROM Sailors S

WHERE (SELECT MAX (S2.age)

FROM Sailors S2)

= S.age

Previous slide

Next slide

Back to first slide

View graphic version