I'm looking for analytical function like PARTITION BY in MySQL (see the docs for more info)
Analytic functions compute an aggregate value based on a group of rows. They differ from aggregate functions in that they return multiple rows for each group.
Does it exist?