min(date) + 1

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?

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_spa
m@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?
>

select top 1 a.date from
(select top 2 date from table order by date ) a
order by a.date desc

On Wed, 21 Sep 2005 23:21:52 GMT, Danny wrote:

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

Hi Danny,

No need to use a derived table, though. This'll work as well:

SELECT MIN(a.date)
FROM   table AS a
WHERE  a.date > (SELECT MIN(b.date) FROM b.table))

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)