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:
![desired result set]()
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:
Microsoft SQL Server 2008
Last Comment
Jim Horn
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Jim but what if I want to show every column like on the screen shot I posted above?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Thanks for the split. Good luck with your project. -Jim