SQL RB AND VS

[Ruslan Zasukhin]

On 2/25/12 3:13 PM, "Christian - ChrisKatDev.com"
<christian at chriskatdev.com> wrote:

> hello,
> 
> why this request don't work :
> delete from dicowords where recid in (select recid from dicowords where
> reciddictionary = 4 limit 1000)

You want delete ANY  first 1000 records?

ANY because you not specify ORDER BY ... So you can get random records in
this set ...

Well, I'd say - first 1000 records in their physical order in table ...


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]