sql – additional condition without partition on


My problem here is that I want the function partition on to start counting lines only from a certain time range.

In this example, if I added rn = 1 at the end, order_id = 5 would be excluded from the results (because the partition is ordered by the date of payment and there is order_id = 6 with an earlier date) but this should not be as I want it, this time range for the score starts from & # 39; 2019-01-10 & # 39;.