Posted by Hugo Kornelis on 10/01/15 11:27

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)

[Back to original message]