Is it possible to use statistical functions in MySQL, such as those already in Oracle? Examples:
- OVER / PARTITION BY
- CORR
- DENSE_VAR
- FIRST
- LAG
- LAST
- RANK
- DENSE_RANK
I know they do not exist natively, but can you simulate them or import some library into MySQL? It would help a lot .