Hi

Check out this previous post:

http://tinyurl.com/q59j

John

"William Jiang" <williamj@qd.lucent.com> wrote in message
news:bm0gon$i2h@netnews.proxy.lucent.com...
> Recently, I will write a database application to get the median value
> according to the grouped condition.
>
> maybe, just like the following.
>
> SELECT Max(a1) MaxValue, Median(a1) MedianValue FROM test_table
>
> Any suggestion?
>
>