/SQL/HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN

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));

Source: eversql.com

Similar codes

0 vote198 views1 answer
Look at running processes redshift
SQL
-2 votes293 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote209 views1 answer
Select new table sql
SQL
0 vote227 views1 answer
Use mysql in java program
SQL
0 vote211 views1 answer
How to alter length character varying postgres
SQL
1 vote204 views3 answers
How to truncate table with foreign key constraint
SQL
5 votes204 views2 answers
Oracle rename table
SQL
0 vote202 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote225 views3 answers
Sql select statements
SQL
2 votes240 views1 answer
Oracle trace session
SQL