Re: date problem

[tony <tony@xxxxxxxx>]

Le lundi 16 mai 2005 à 10:30 +0200, Roman Neuhauser a écrit :

>     select *
>     from expo
>     where date = (select max(date)
>                   from expo
>                   where date < now()) as x;

Thanks!

I keep forgetting this for some strange reason... I was putting it in
the "from" instead of the "where"

Tony


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)