Select latest one from each category (group-wise max in a group query)

 

How to select latest one from each category (group-wise max in a group query)

Suppose we have this \’catalogs\’ table –

This query will select the latest one from each category –

Leave a Reply

Your email address will not be published. Required fields are marked *