SyntaxFix
Write A Post
Hire A Developer
Questions
Here is the simplest solution
select m_id,v_id,max(timestamp) from table group by m_id;
Group by m_id but get max of timestamp for each m_id.