How to code a query in postgres and show each record when price changes in a series of data

Question

Highlighted in yellow are the records that will be the result set.

Answer 1

You can try to use ROW_NUMBER window function.

SELECT *
FROM (
    SELECT *,ROW_NUMBER() OVER(PARTITION BY beast_bid_price ORDER BY posted DESC) rn
    FROM T
) t1
WHERE rn = 1