Blair Adamache <badamache@2muchspam.yahoo.com> writes:

> You don't have to use row_number in v8 - this syntax will work:
>
> delete from address where name in
> (select name from address
> order by name
> fetch first 1 row only)

Cool.

Do we support the new goodies on Common Table Expressions too ?

--
#include <disclaimer.std> /* I don't speak for IBM ... */
/* Heck, I don't even speak for myself */
/* Don't believe me ? Ask my wife :-) */
Richard D. Latham lathamr@us.ibm.com