Hello SQL Expert,
I have a basic query:
SELECT TYPE,EMP_ID,START_DATE,GROUP
FROM EMPTBL
And here is the output when I run the above query.
What I am trying to do is to get MAX of StartDate and keep all the fields. What I need
is to get one record only which is MAX date but because of various GROUP, I am having
more than one record. How do I achieve this so I can have the output like below?
Thanks all