SQL query to select the current attributes of an entity from a log type table

Question

SQL

There is a table where entity attributes are stored, for example, the product ID, its price and the date of the last update. When adding a new price, a row ('item-id', 'new price', 'time of adding') is inserted into the table. How to get a selection with current prices for all products?

Answer 1

select id, price, date_modified
from prices where id ,
date_modified in ( select id, max (
date_modified)
from prices
group by id
) by id order by date_modified desc) from prices

Answer 2

It is possible without a subquery:
select id, price, date_modified from prices
group by id
having date_modified = max(date_modified)