Thread: max() question

max() question

From
Hitesh Patel
Date:
I have a table with and email address and a datetime timestamp.  What
would be the easiest way to select the 3 earliest timestamps (earliest
being furthest in the past from the current date)

Re: [GENERAL] max() question

From
"Aaron J. Seigo"
Date:
On Tue, 14 Sep 1999, you wrote:
> I have a table with and email address and a datetime timestamp.  What
> would be the easiest way to select the 3 earliest timestamps (earliest
> being furthest in the past from the current date)

lots of ways =) though the first that comes to mind is the use of cursors.
order by DATEFIELD asc and just grab the first three.. or if that don't work for
ya (for whatever reason)... you could select the min(DATEFIELD), then select the
min(DATEFIELD) where DATEFIELD > (that last select's return), then again for
the third... this is convoluted, but if you are doing this over a network, a
cursor may not be the easiest thing to implement, depending on what you are
using. as for performance of this? i dunno. cursor would be best.

--
Aaron J. Seigo
Sys Admin

Re: [GENERAL] max() question

From
Michael Simms
Date:
>
> On Tue, 14 Sep 1999, you wrote:
> > I have a table with and email address and a datetime timestamp.  What
> > would be the easiest way to select the 3 earliest timestamps (earliest
> > being furthest in the past from the current date)
>
> lots of ways =) though the first that comes to mind is the use of cursors.
> order by DATEFIELD asc and just grab the first three.. or if that don't work for
> ya (for whatever reason)... you could select the min(DATEFIELD), then select the
> min(DATEFIELD) where DATEFIELD > (that last select's return), then again for
> the third... this is convoluted, but if you are doing this over a network, a
> cursor may not be the easiest thing to implement, depending on what you are
> using. as for performance of this? i dunno. cursor would be best.

Hows about:

select * from table order by timestamp limit 3

That should do it

                    ~Michael