Re: SQL question
From: <hpujol_at_dwp.la.ca.us>
Date: 8 Nov 93 21:39:06 GMT
Message-ID: <911_at_dwp.la.ca.us>
Date: 8 Nov 93 21:39:06 GMT
Message-ID: <911_at_dwp.la.ca.us>
I believe this will give you the result:
select FIELD_A FROM TABLE_NAME WHERE FIELD_B = (SELECT MAX(FIELD_B) FROM TABLE_NAME)
It would be very prudent to have an index defined for FIELD_B!
Hector Pujol L.A. Dept. of Water and PowerReceived on Mon Nov 08 1993 - 22:39:06 CET