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 vote267 views1 answer
Set statiscis on in ssms
SQL
1 vote245 views1 answer
Select not matching data from two tables
SQL
1 vote263 views1 answer
Postgres concat_ws
SQL
0 vote250 views1 answer
Difference between 2 query results sql server
SQL
2 votes248 views1 answer
Oracle sql query to make column data uppercase
SQL
6 votes262 views2 answers
Mysql version check cmd
SQL
0 vote261 views1 answer
How to order result of subquery in select
SQL
0 vote280 views5 answers
Mode sql course
SQL
0 vote276 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
0 vote277 views1 answer
Psql list rules
SQL