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 vote254 views1 answer
How to count with except in psql
SQL
0 vote315 views1 answer
Sql to excel pgadmin
SQL
-1 vote216 views3 answers
Ubuntu install mssql
SQL
0 vote271 views1 answer
Dump multiple tables mysql
SQL
0 vote275 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote253 views1 answer
Mysql find non alphanumeric characters
SQL
0 vote293 views1 answer
The package java.sql is not accessible
SQL
2 votes273 views1 answer
Get first 2 letter in sql
SQL
0 vote284 views1 answer
Search mysql database for column
SQL
1 vote224 views1 answer
Mysql see column types
SQL