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 vote124 views1 answer
Mysql query single row
SQL
0 vote126 views1 answer
Mysql trim characters
SQL
32 votes135 views6 answers
How to change column name in sql
SQL
0 vote112 views1 answer
Oracle sql count occurrences of value in column
SQL
0 vote119 views1 answer
Zerar auto increment mysql
SQL
4 votes128 views3 answers
Sqlite show columns
SQL
11 votes132 views2 answers
Turn off safe mode mysql
SQL
0 vote124 views1 answer
Show the colums of table sql
SQL
1 vote113 views1 answer
Sql alchemy with azuresql server
SQL
7 votes121 views1 answer
Append column sql
SQL