In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!
select r.* from review as r inner join ( select rev_id,max(create_date) as max_dat from review group by rev_id ) as rev_max on r.rev_id = rev_max.rev_id and r.create_date = rev_max.create_date
Join the community of 500,000 technology professionals and ask your questions.