Find the median in sql

# FOR TABLES WITH ODD NUMBER OF ROWS

# For column1 in table1 with 'n' number of rows. Where 'n' is an odd number.
# 1. Change all column1 and table1 to your column and table name.
# 2. Calculate (n/2)+0.5, where n=number of rows, and set it as LIMIT for t1.

SELECT *
FROM (SELECT column1
      FROM table1
      ORDER BY column1
      LIMIT (n/2)+0.5) AS t1
ORDER BY column1 DESC
LIMIT 1;

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 vote301 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
10 votes329 views4 answers
Sql server pagination
SQL
6 votes300 views1 answer
Oracle trigger after logon on database
SQL
0 vote265 views2 answers
Mysql output csv
SQL
6 votes292 views3 answers
Mysql create database utf8
SQL
3 votes282 views2 answers
Sql paging query
SQL
2 votes273 views1 answer
Date conversion in mysql column
SQL
0 vote291 views1 answer
Show the colums of table sql
SQL
0 vote275 views1 answer
Allow external access to mysql
SQL
25 votes306 views1 answer
How to update an attribute in MySQL
SQL