Retrieving field values of record found with MAX

[Steven Ronald]

Ruslan,

I have a database xdb:

foo     bar
4         3.3
2        4.5
9         1.8

I want to find the value of "bar" for the record with
the maximum value of "foo" (ie 1.8).

Is there a way to do this with a single SQL statement?

I tried this:

cursorRef=valSQLSelect( dbRef_xdb, "SELECT
MAX(foo),bar FROM x");

but it doesn't work, I get "0" for bar.

Best Regards,
Steven

Send instant messages to your online friends http://au.messenger.yahoo.com