Percentil mysql

percentil.sql

select floor(20/100*(count(*))) as min, floor(80/100*(count(*))) as max  
from produto
order by valor
limit min, max;


select min, max  
from (SELECT valor, floor(20/100*(count(*))) as min, floor(80/100*(count(*))) as max FROM produto group by fornecedor_id) produto
order by valor
limit 0, 4;


DELIMITER &&
    CREATE PROCEDURE sp_percentil( IN var_min INT, var_max INT )

	BEGIN
     
		SELECT min, max  
		FROM (SELECT valor, floor(var_min/100*(count(*))) as min, floor(var_max/100*(count(*))) as max FROM produto group BY fornecedor_id) produto
		ORDER BY valor
		LIMIT 0, 4;

	END
&&