Apr 22, 2022
SELECT
m.user_id,
m.orderprice
FROM
(
SELECT
user_id,
orderprice,
DENSE_RANK() OVER (PARTITION BY user_id ORDER BY orderprice DESC) AS rank
FROM
table_name
) as m
WHERE
m.rank = 2
Written by Charlie Fay
I write about Salesforce Marketing Cloud, Marketing Automation, Development and Programmatic Languages. I enjoy solving complex problems with simplicity.