group by
598866Oct 1 2007 — edited Oct 1 2007how could I get the MAX value on my query if there is a null record? this is my data
emp_id first_name last_name email
12 ana taylor ataylor@email.com
14 ana taylor
15 ana taylor
my query:
SELECT MAX(EMP_ID), FIRST_NAME, LAST_NAME, EMAIL
FROM EMP
GROUP BY FIRST_NAME, LAST_NAME, EMAIL
still the same output..