On 4/12/07, Raymond O'Donnell <rod@xxxxxx> 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
