Hands-on task
PostgreSQL: RANK window function
In the shop database, for each order output name|amount|rank, where the rank is the order's position by descending amount (RANK()). Write the result, sorted by descending amount, to /root/ranked.txt.
- window functions
- rank
- over
- postgresql
- psql