how to find median of a column sql

Solutions on MaxInterview for how to find median of a column sql by the best coders in the world

showing results for - "how to find median of a column sql"

1SET @rowindex := -1;
2 
3SELECT
4   AVG(g.grade)
5FROM
6   (SELECT @rowindex:=@rowindex + 1 AS rowindex,
7           grades.grade AS grade
8    FROM grades
9    ORDER BY grades.grade) AS g
10WHERE
11g.rowindex IN (FLOOR(@rowindex / 2) , CEIL(@rowindex / 2));
12

similar questions

find difference in dates sql sql avg and group by how to find average in sql sql average sql datediff month sql query to find difference between total no of rows and distinct rows in sql server difference between unique vs primary key in sql sql find all different values in column difference in dates sql above average salary in sql average salary in sql find below average salary in sql sql avg group by find the median in sql median mysql select all same column value in sql sql avg 28 29

queries leading to this page

sql get median of a column how to query median in sql select median sql sql find median of column sql median value select median in sql sql server median get the median in sql how to find median of a column sql to find median of data in sql query median of a column in sql sql query to find median using floor to find median in sql sql find median sql query to find median value how to find median of a column in sql how to find the median in sql calculate median in sql median of data in sql find the median in sql sql median how to find the median sql median function get median of row sql sql find median value median in sql sql get median sql calculate median calculate median sql how to find median in sql median sql server function finding the median value from raw data in sql count median sql finding median using sql how to calculate median in sql median sql sql select the median how to get median by date sql median function in sql sql take median of operation find median sql sql select median how to get median of a column in sql median in sql query how to calculate median value in sql querying the median sql how to get median of some field in sql how to find median in sql query calculate median value in sql get median of sql column find median in sql sql median category median of column sql get median in sql selecting median in sql finding the median in sql sql median of column how to get median sql how to find median of a column sql