最大值和最小值的时间戳

你可以用 ROW_NUMBER 两次:

WITH cte AS (
    SELECT id, product_id, price, timestamp,
        ROW_NUMBER() OVER (ORDER BY price) rn_min,
        ROW_NUMBER() OVER (ORDER BY price DESC) rn_max
    FROM yourTable
)

SELECT 'min' AS label, price, timestamp FROM cte WHERE rn_min = 1
UNION ALL
SELECT 'max', price, timestamp FROM cte WHERE rn_max = 1;

如果你不想 min 和 max 标签(价格本身给出哪一个是最小的,哪一个是最大的),那么你可以用这个:

SELECT price, timestamp FROM cte WHERE rn_min = 1 OR rn_max = 1;