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 vote229 views1 answer
Postgres - Login and connect as default user
SQL
0 vote210 views3 answers
Sql drop all tables
SQL
1 vote231 views2 answers
Truncate table sqlite
SQL
1 vote210 views1 answer
Get table column names sql ssms
SQL
0 vote195 views1 answer
Get last updated row sql server
SQL
0 vote206 views1 answer
Subquery aggregation
SQL
0 vote210 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote199 views1 answer
Oracle sql date winter time
SQL
0 vote221 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
4 votes210 views2 answers
Postgre sql create table
SQL