I'm using ORDER BY for that purpose !
For example:

SELECT *
FROM TABLE1
ORDER BY FIELD1 DESC

First row will have maximum value for FIELD1

HTH
Rado Antloga

----- Original Message -----
From: "ibrahim Bulut" <ibrahim@...>
To: <ib-support@yahoogroups.com>
Sent: Thursday, April 11, 2002 9:06 AM
Subject: Re: [ib-support] How do I select a record which has the highest for
a particular column


> 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/
> >
> >
> >
>
>
>
> 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/
>
>
>