i'm using sql server 2008.
I have a table that looks like this:
How would I write a query that looks at the EVENTDATETIME column and returns the most recent concert for each artist.
So the result set would show only the most recent concert for each artist.
The result set would look something like this: