Help needed: Oracle ans SQL

Hi!

I've got a serious problem:

I've got a table with key/value-pairs and an appropriate level. I'm searching for a query which results in a table that lists only the key/value-pairs with the greatest level.

Example:

key value level

name   alice        1
age       13        1
name     bob        2
name   cindy        3
gender  male        1
age       15        2

The query should have the following result:

key value level

age        15       2
gender   male       2
name    cindy       3

Can anybody help me?

Mirko Received on Tue Oct 16 2001 - 04:32:10 CDT