|
|
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)
Navigation:
[Reply to this message]
|