Select ID ,Max(VALUE)
from TABLE
group by ID;
lily99_at_my-deja.com wrote in message <80ud2e$rui$1_at_nnrp1.deja.com>...
>Hi,
> Here is my question:
> I have a table that has the following info
> ID Value
> 1 35
> 1 24
> 1 13
> 1 8
> 1 4
> 2 81
> 2 60
> 2 20
> 2 10
> 2 4
> 3 9
> 3 8
> 3 6
> 3 5
>
>How can I extract third largest value for each ID, this means I
>will get result as:
> ID Value
> 1 13
> 2 20
> 3 6
>
>Can someone help me with this issue? Thanks in advance.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Nov 17 1999 - 08:37:51 CST
