I'm brand new to SQL but can usually pick up programming pretty easy so this is frustrating. When I see the example code for this solution, I'm not sure how to interpret it. Excuse my ignorance, please!!
When this code says to select "r", is that a dummy table name or is the user meant to insert the name of the table with the data in it? And is create_date something you leave in there, or do you define it elsewhere, or insert your own date? Is rev_id the id you want to group by?
Just simple, quick descriptions of what these terms are referring to would help me so much and would be greatly appreciated.
select r.* from review as r
select rev_id,max(create_date) as max_dat
group by rev_id
) as rev_max on r.rev_id = rev_max.rev_id and r.create_date = rev_max.create_date