SQL question

Suppose I have a table with a key field (FIELD_A) an integer field (FIELD_B) and a bunch of other fields. How can I get the maximum FIELD_B and its FIELD_A value using one query?

It seems like it's almost like this:

select FIELD_A, max(FIELD_B)
from table_name;

But not quite.

Thanks,

Gary Kephart
kephartg_at_roses.dny.rockwell.com Received on Sat Nov 06 1993 - 02:29:56 CET