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

1 vote164 views1 answer
Nested if in mysql
SQL
0 vote185 views1 answer
Use between operator in mysql
SQL
2 votes192 views2 answers
Change mysql password from command line
SQL
0 vote250 views1 answer
How to find sql server name
SQL
0 vote227 views2 answers
Dbms interview questions
SQL
1 vote176 views1 answer
Oracle sql assign unique number to each grouping
SQL
4 votes185 views1 answer
Update table from another table oracle
SQL
1 vote196 views1 answer
Mysql not supported auth mode
SQL
0 vote211 views2 answers
Search stored procedures
SQL
11 votes217 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL