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 vote341 views1 answer
Sql database connectivity
SQL
3 votes331 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
1 vote411 views1 answer
OSError: mysql_config not found
SQL
0 vote356 views1 answer
Get null value in sql
SQL
0 vote393 views1 answer
Traccar mysql
SQL
-1 vote347 views1 answer
Mysql change database charset and collation
SQL
-1 vote345 views3 answers
Error mysql shutdown unexpectedly
SQL
1 vote357 views1 answer
Oracle stop
SQL
4 votes332 views1 answer
To date oracle with time
SQL
0 vote350 views1 answer
Sql count total by foreign key
SQL