Return rowid with max()

Greetings,

Say I have a table with two columns: name, score. I want to get name of the highest score. I wrote following SQL statement:

select name from tbl where score = (
  select max(score) from tbl)

The statement includes two select, is there a way to use only one select to get the name of highest score's name?

Thanks in advance!
Evan Received on Sun Aug 03 2003 - 22:56:59 CDT