Posted by Danny on 09/22/05 02:21

Try somehthing like...

select min(a.date) from (select date from table b where b.date > (select
min(c.date) from table c)) a

This should get the next earliest date not necessarily the next min date if
there are duplicate min dates.


<imani_technology_spam@yahoo.com> wrote in message
news:1127338921.903049.218810@z14g2000cwz.googlegroups.com...
>I know you can use the min function to get the first date within a
> recordset. However, is there a way to get the second date in a
> recordset? In other words, is there a way to get "min(date) + 1" or a
> "next-to-earliest date" essentially?
>

[Back to original message]