i have one table employees
with several fields, i want the oldest emplyoee familyname
(date_hired)



SELECT EMPLOYEES.EMP_FAMILY_NAME , MAX(EMPLOYEES.DATE_HIRED)
FROM EMPLOYEES
WHERE EMPLOYEES.DATE_RELEASED IS NULL
GROUP BY EMPLOYEES.EMP_FAMILY_NAME;


this give me several results and the date as well
it i snot what iwant i just want one or several (if same date) family
name.

thanks

Oracle LazyDBA home page