HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
/*
HACKER RANK MYSQL SOLUTION.
*/
SET @rowindex := -1;
SELECT
ROUND(AVG(N.LAT_N),4)
FROM
(SELECT @rowindex:=@rowindex + 1 AS rowindex,
STATION.LAT_N AS LAT_N
FROM STATION
ORDER BY STATION.LAT_N) AS N
WHERE
N.rowindex IN (FLOOR(@rowindex / 2) , CEIL(@rowindex / 2));how to find median of a column sql
SET @rowindex := -1;
SELECT
AVG(g.grade)
FROM
(SELECT @rowindex:=@rowindex + 1 AS rowindex,
grades.grade AS grade
FROM grades
ORDER BY grades.grade) AS g
WHERE
g.rowindex IN (FLOOR(@rowindex / 2) , CEIL(@rowindex / 2));Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
