Re: SQL - finding next date

On 4/12/07, Raymond O'Donnell <rod@iol.ie> wrote:
> On 11/04/2007 21:15, Jon Sime wrote:
>
> >> This is probably a very simple one, but I just can't see the answer and
> >> it's driving me nuts. I have a table holding details of academic terms,
>
> Many thanks indeed to all who replied - I particularly like Jeff's
> solution, and will use that one.

I think this is by far the cleanest:

select * from term where start_date > (select start_date from term
where name = 'foo') order by start_date limit 1;

merlin