Select f1, min(f2) ????

Hello All

Could someone point out if there a way
of selecting two fields from the table when one field reaches for example its minimum.

I don't like the following because I think that it may be done more efficiently, because f1 is found at the time of subquery.

select f1, f2 from t1 where f2=min( select f2 from t1

        where (<<criteria>>));

For simplicity lets assume that all f2 are different.

Konstanti Received on Sun May 12 1996 - 00:00:00 CEST