Untitled
Anonymous
plain_text
04/20/2023 8:19 PM
208 B
10
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;