Is there a way to prevent ROW_NUMBER's ORDER BY from having to repeat the same thing?

Is there a way to prevent ROW_NUMBER's ORDER BY from having to repeat the same thing?
I hope you found a solution that worked for you :)
The Content is licensed under (https://meta.stackexchange.com/help/l...) CC BY-SA.
Attention! This video does always use the same license as the source!
Thanks to all those great people for their contributions!

(stackoverflow.com/users/1634905/sudoexclamationexclamation)sudoExclamationExclamation
(stackoverflow.com/users/271959/frank-heikens)Frank Heikens
(stackoverflow.com/users/5298879/zegarek)Zegarek
(stackoverflow.com/users/6892541/ahmed-amin-shahin)Ahmed Amin Shahin
A special thanks goes out to the (stackoverflow.com/questions/79320823/is-there-a-way-to-prevent-row-numbers-order-by-from-having-to-repeat-the-same-t)Stackexchange community

I wish you all a wonderful day! Stay safe :)
If anything is off, please write me at peter D.O.T schneider A.T ois42.de

sql postgres16 postgres15 postgresql