How to transfer the oracle function PERCENT_RANK to mysql?
oracle example: SELECT PERCENT_RANK(11000) WITHIN GROUP (ORDER BY salary DESC) "Rank of $11,000 among managers" FROM employees WHERE job_id LIKE '%MAN' OR job_id LIKE '%MGR';
How to transfer the oracle function PERCENT_RANK to mysql?
oracle example: SELECT PERCENT_RANK(11000) WITHIN GROUP (ORDER BY salary DESC) "Rank of $11,000 among managers" FROM employees WHERE job_id LIKE '%MAN' OR job_id LIKE '%MGR';