This section contains reference documentation for the ROW_NUMBER function.
Assigns a row number to all the rows in a specified table.
bigint()
Order transactions by the payment date and assign them row numbers.
Find the number of transactions ranked for each customer. The customer with the highest number of transactions will have a rank of 1, and so on. Order records by the total transactions in descending order. In your rankings, return a unique rank value (to cover multiple customers with the same number of transactions).
\
customer_id | payment_date | amount | row_number |
---|---|---|---|
row_number | customer_id | payment_date | amount |
---|---|---|---|
customer_id | count | row_number |
---|---|---|
416
2023-02-14 21:21:59.996577
2.99
516
2023-02-14 21:23:39.996577
4.99
239
2023-02-14 21:29:00.996577
4.99
592
2023-02-14 21:41:12.996577
6.99
49
2023-02-14 21:44:52.996577
0.99
264
2023-02-14 21:44:53.996577
3.99
46
2023-02-14 21:45:29.996577
4.99
481
2023-02-14 22:03:35.996577
2.99
139
2023-02-14 22:11:22.996577
2.99
595
2023-02-14 22:16:01.996577
2.99
1
1
2023-02-15 19:37:12.996577
2
1
2023-04-11 08:42:12.996577
1
2
2023-04-30 12:16:09.996577
2
2
2023-04-30 14:49:39.996577
1
3
2023-04-27 18:51:38.996577
2
3
2023-03-21 19:19:14.996577
1
4
2023-03-18 03:43:10.996577
2
4
2023-03-20 11:24:06.996577
148
45
1
245
42
2
144
39
3
253
39
4
410
36
5
368
34
6