Untitled
unknown
plain_text
3 years ago
154 B
3
Indexable
WITH p AS
(SELECT *,
ROW_NUMBER() OVER (ORDER BY paid_at) AS rang
FROM tools_shop.orders)
SELECT total_amt
FROM p
WHERE rang = 50;
Editor is loading...
WITH p AS
(SELECT *,
ROW_NUMBER() OVER (ORDER BY paid_at) AS rang
FROM tools_shop.orders)
SELECT total_amt
FROM p
WHERE rang = 50;