AlgorithmJourney/LeetCode/sql/LeetCode1831.sql at main · HenryJi529/AlgorithmJourney · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
select transaction_id
from (
        select
            transaction_id, `day`, amount, rank() over (
                partition by
                    DATE_FORMAT(`day`, "%y-%m-%d")
                order by amount desc
            ) ranking
        from Transactions
    ) t
where
    ranking = 1
order by transaction_id;