SQL QUERY - NO DUPLICATE RESULTS

Question

I have the below table, named shop:

Can you suggest the query to have no duplicate "product" results associated with the most recent delivery date.

Thanks

Answer 1

select product, max(delivery_date) from table
group by product

Answer 2

SELECT
product, 
MAX(delivery_date) as most_recent_delivery_date 
FROM table_name
GROUP BY product;

Answer 3

If you want just the product, you can use aggregation as in the other answers. If you want the complete row, then one method is:

select t.*
from (select t.*,
             row_number() over (partition by product order by delivery_date desc) as seqnum
      from t
     ) t
where seqnum = 1;