Hello SQL Expert,
I have a basic query:
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?