Breaking News: Grepper is joining You.com. Read the official announcement!

HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN

Aggressive Aardvark answered on November 10, 2020 Popularity 9/10 Helpfulness 3/10

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

related how to find median of a column sql

HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN

Comment

/*
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));

Popularity 9/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: find median sql

Link to this answer
Share Copy Link

Contributed on Nov 14 2021

Aggressive Aardvark

0 Answers Avg Quality 2/10

Closely Related Answers

how to find median of a column sql

Comments(1)

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

Popularity 9/10 Helpfulness 1/10 Language sql

Source: www.eversql.com

Tags: find

Link to this answer
Share Copy Link

Contributed on Nov 10 2020

Disgusted Dingo

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN

Contents

More Related Answers

HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN

Closely Related Answers

how to find median of a column sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.