Breaking News: Grepper is joining You.com. Read the official announcement!

MySQL Quartiles in SQL query

Cleo answered on March 20, 2022 Popularity 4/10 Helpfulness 1/10

answer MySQL Quartiles in SQL query

MySQL Quartiles in SQL query

Comment

SET @number_of_rows := (SELECT COUNT(*) FROM LuxLog);
SET @quartile := (ROUND(@number_of_rows*0.25));
SET @sql_q1 := (CONCAT('(SELECT "Q1" AS quartile_name , Lux, Sensor FROM LuxLog ORDER BY Lux DESC LIMIT 1 OFFSET ', @quartile,')'));
SET @sql_q3 := (CONCAT('( SELECT "Q3" AS quartile_name , Lux, Sensor FROM LuxLog ORDER BY Lux ASC LIMIT 1 OFFSET ', @quartile,');'));
SET @sql := (CONCAT(@sql_q1,' UNION ',@sql_q3));
PREPARE stmt1 FROM @sql;
EXECUTE stmt1;

Popularity 4/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: mysql sql

Link to this answer
Share Copy Link