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

2 votes112 views1 answer
Oracle cpu per session
SQL
1 vote125 views2 answers
Mysql limit offset
SQL
0 vote110 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote115 views2 answers
Find Overlapping sql
SQL
0 vote113 views1 answer
Deny select insert update delete sql
SQL
1 vote137 views1 answer
Key validation sql
SQL
0 vote122 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote122 views1 answer
Oracle show running job
SQL
0 vote90 views1 answer
CREATE MULTIPLE FK
SQL
4 votes114 views1 answer
Oracle select first 10 rows
SQL