Help with select

Hi,
  Here is my question, I have a table that include following info:

   ID         Value
    1           250
    1           270
    1           250
    1           103
    1           100
    2           98
    2           76
    2           57
    2           34
    2           26
    2           12
    3           1000
    3           980
    3           460
    3           300
    3           137

How can I extract the third largest value with each ID, the result I wish to have is:

   ID         Value
    1          250
    2          57
    3          460

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 - 10:48:04 CST