find the median in sql

# FOR TABLES WITH EVEN NUMBER OF ROWS

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

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

View another examples Add Own solution

4.67

Ali Noormohammadi 105 points

                                    SET @rowindex := -1;
&nbsp;
SELECT
&nbsp;&nbsp;&nbsp;AVG(g.grade)
FROM
&nbsp;&nbsp;&nbsp;(SELECT @rowindex:=@rowindex + 1 AS rowindex,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;grades.grade AS grade
&nbsp;&nbsp;&nbsp;&nbsp;FROM grades
&nbsp;&nbsp;&nbsp;&nbsp;ORDER BY grades.grade) AS g
WHERE
g.rowindex IN (FLOOR(@rowindex / 2) , CEIL(@rowindex / 2));

Thank you! 3

4.67 (3 Votes)

3.63

Social_Studies_Student 95 points

                                    # 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;

Thank you! 8

3.63 (8 Votes)

Are there any code examples left?

Find Add Code snippet

New code examples in category SQL

SQL 2022-03-27 22:45:25 how to get mysql on ubuntu
SQL 2022-03-27 20:00:47 install latest mysql on debian 9
SQL 2022-03-27 19:45:11 sql '=' cannot be applied to date varchar(10) athena
SQL 2022-03-27 19:20:41 sql is not null
SQL 2022-03-27 19:20:39 sql group by error
SQL 2022-03-27 18:35:10 replace null with 0 in sql
SQL 2022-03-27 17:30:32 concat column value of same user in mysql
SQL 2022-03-27 17:05:02 sql developer sql worksheet not showing
SQL 2022-03-27 16:45:07 kill a pid redshift
SQL 2022-03-27 16:00:09 joins in sql server

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

finding the median value from raw data in sql finding the median value in sql querying the median sql get median of row sql median in sql server median() sql find the median in sql select median in sql finding median using sql HOW TO GET MEDIAN OF SOME FIELD IN SQL using FLOOR to find median in SQL how to query median in sql how to get median of a column in sql how to find median of a column in sql how to get median sql how to calculate median in sql to find median of data in sql query how to calculate median value in sql calculate median value in sql sql median value finding the median in sql sql find median value sql select the median sql query to find median value get median of sql column sql get median of a column sql query to find median find median in sql sql calculate median sql find median of column sql find median get the median in sql median of a column in sql count median sql sql median function how to find median in sql query how to find the median median of column sql median function in sql sql server median how to find the median in sql sql median of column calculate median sql median sql server function median of data in sql how to find median in sql calculate median in sql median in sql find median sql median in sql query sql get median sql select median select median sql median sql sql take median of operation sql median category sql median how to find median of a column sql

find the median in sql

Welcome Back!

Create a Free Account