/SQL/HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN

HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN

/*
HACKER RANK MYSQL SOLUTION.
*/
SET @rowindex := -1;
 
SELECT
   ROUND(AVG(N.LAT_N),4)
FROM
   (SELECT @rowindex:=@rowindex + 1 AS rowindex,
           STATION.LAT_N AS LAT_N
    FROM STATION
    ORDER BY STATION.LAT_N) AS N
WHERE
N.rowindex IN (FLOOR(@rowindex / 2) , CEIL(@rowindex / 2));

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 vote355 views1 answer
How to get previous year from sysdate in oracle
SQL
5 votes325 views3 answers
Truncate function in sql oracle
SQL
0 vote387 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
3 votes354 views2 answers
Postgres show table schema
SQL
10 votes326 views3 answers
Sql limit results
SQL
2 votes333 views3 answers
Write sql query to find the second highest salary of employee
SQL
3 votes376 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote310 views2 answers
Spring properties file for db
SQL
0 vote333 views1 answer
Oracle create table auto generated primary key
SQL
0 vote386 views1 answer
How to inner join 4 tables in sql
SQL