I'm trying to get the youngest pilot's name and age but all the pilots show up:
select pil_pilotname, round(min(sysdate-pil_brthdate)/365.25,0) "Age"
from pilots
group by pil_pilotname;
What's missing?
Thanks.
Results 1 to 3 of 3
Threaded View
|
|
|