maqskywalker
asked on
t-sql max date of table
i'm using sql server 2008.
I have a table that looks like this:
http://sqlfiddle.com/#!3/6e117/2
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:
I have a table that looks like this:
http://sqlfiddle.com/#!3/6e117/2
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:
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the split. Good luck with your project. -Jim
ASKER