SQL - obtaining median and quartiles - TechRepublic
General discussion
January 11, 2001 at 09:37 AM
dsandbrook

SQL — obtaining median and quartiles

by dsandbrook . Updated 25 years, 4 months ago

Oracle SQLPlus or PL/SQL or ?

A large table with daily weather
observations over 50 years.

I am trying to list the median and quartiles grouped by day of the year. Because of missing records there are not 50 records for each date – number varies.

Anyone have a SQL script for this?

This discussion is locked

All Comments