Re: median value

Lisa Kilroy wrote:
> I need to pull the median value out of a table for a particular field.

[Quoted] Hello Lisa, no problem!

SELECT MAX (value)
FROM table
WHERE value <= (
[Quoted]   SELECT AVG (value)
  FROM table
)

[Quoted] [Quoted] This might not be the fastest way but it works.

-- 
[Quoted] Sport radio: people listening to people watching people having fun
Mailto:roger.wernersson_at_adra.se
BTW: All opinions are mine, all mine, and nobody's but mine.