SELECT * FROM TABLE1
WHERE FIELD1 = (SELECT MAX(FIELD1) FROM TABLE1)


Ibrahim Bulut
Software Developer
Republic of Turkey

----- Original Message -----
From: "Amrita Chaudhury" <achaudhu@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, April 10, 2002 10:21 PM
Subject: [ib-support] How do I select a record which has the highest for a
particular column


> Please help !!!
>
> I cant do select * from report_new(date) where attempts= max(attampts).
> Where attempts is a column..
>
> What is the closest way to get the entire record, I dont want to invoke
the
> procedure twice ?
>
> amrita .
>
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>