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.

• Third query equivalent to second query

  • allowed in SQL/92 standard, but 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