Обсуждение: Re: delete using limit

hi,

loop wrote, On 3/18/2004 19:20:
> Hi,
> how can I use delete with a limit variable?
> DELETE FROM table WHERE field='x' LIMIT x

delete from table where field in (select field from table limit x);

C.