On 4/12/07, Raymond O'Donnell <rod(at)iol(dot)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