p.197-8
"Find the name and age of the oldest sailor"
SELECT S.name, S.age
FROM Sailors S
WHERE S.age = (SELECT MAX (S2.age)
FROM Sailors S2)
Previous slide
Next slide
Back to first slide
View graphic version