Re: How to get the date of each price change in the Northwind database?

[Peter Brawley]

Something like this?

SELECT * 
FROM (
  SELECT
    productid, startdate,enddate,standardcost,
    LAG(standardcost, 1) OVER (
        PARTITION BY productid
        ORDER BY startdate
    ) as prev_cost
  FROM products
) x
WHERE standardcost<>prev_cost;