Help with select

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:11:27 CST