<div>
The parser doesn't understand (neither do I) why you would want to do an order by within a subselect when the subselect is used in combination with the in() keyword.
</div><div>I think your query should read:</div><div><br></div><div><blockquote type="cite" style="border-left-style: solid; border-left-color: rgb(0, 33, 98); color: rgb(0, 33, 98); border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; margin-left: 0px; padding-left: 10px; padding-right: 0px; margin-right: 0px; "><span><div><div><div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font size="3"><span style="background-color: transparent; ">delete from dicowords where recid in (select recid from dicowords where reciddictionary = 4 )</span></font></div></div></div></div></div></span></blockquote><div><span style="font-size: 13px; ">delete from dicowords where recid in (select recid from dicowords where reciddictionary = 4 limit 1000). I am not sure that the limit clause will be accepted</span></div><div><br></div><div><font size="3">hth</font> </div></div>
<div><div><br></div><div>-- </div><div>Bart Pietercil</div><div>CTO Cognosis NV</div><div>Dorpstraat 28</div><div>3560 Lummen<br></div><div><br></div></div>
<p style="color: #A0A0A8;">On Saturday 25 February 2012 at 15:32, Christian - ChrisKatDev.com wrote:</p>
<blockquote type="cite" style="border-left-style:solid;border-width:1px;margin-left:0px;padding-left:10px;">
<span><div><div><span style="background-color: transparent;">Hi Ruslan,</span><div><span style="background-color: transparent;"><br></span></div><div><span style="background-color: transparent;">I have 500,0000 record in database.</span></div><div><span style="background-color: transparent;">Where I want delete without limit, I have a crash (database diagnose : ok)</span></div><div><span style="background-color: transparent;"><br></span></div><div><span style="background-color: transparent;">I have tried :</span></div><blockquote type="cite"><div><blockquote type="cite"><div></div></blockquote></div></blockquote><div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font size="3"><span style="background-color: transparent;">delete from dicowords where recid in (select recid from dicowords where reciddictionary = 4 ORDER BY recid limit 1000)</span></font></div></div></div><div><span style="background-color: transparent;"><br></span></div><div><span style="background-color: transparent;"> but I have this error...</span></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font size="3"><span style="background-color: transparent;">15:28:50 Kernel error: 0x71000. line 1:93: expecting ')', found 'ORDER'</span></font></div></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font size="3"><span style="background-color: transparent;"><br></span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font size="3"><span style="background-color: transparent;">??</span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font size="3"><span style="background-color: transparent;"><br></span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font size="3"><span style="background-color: transparent;">Christian</span></font></div><div><br><div><div>Le 25 févr. 2012 à 15:03, Ruslan Zasukhin a écrit :</div><br><blockquote type="cite"><div>On 2/25/12 3:13 PM, "Christian - <a href="http://ChrisKatDev.com">ChrisKatDev.com</a>"<br><<a href="mailto:christian@chriskatdev.com">christian@chriskatdev.com</a>> wrote:<br><br><blockquote type="cite"><div>hello,<br></div><div><br></div><div>why this request don't work :<br></div><div>delete from dicowords where recid in (select recid from dicowords where<br></div><div>reciddictionary = 4 limit 1000)<br></div></blockquote><br>You want delete ANY first 1000 records?<br><br>ANY because you not specify ORDER BY ... So you can get random records in<br>this set ...<br><br>Well, I'd say - first 1000 records in their physical order in table ...<br><br><br>-- <br>Best regards,<br><br>Ruslan Zasukhin<br>VP Engineering and New Technology<br>Paradigma Software, Inc<br><br>Valentina - Joining Worlds of Information<br><a href="http://www.paradigmasoft.com">http://www.paradigmasoft.com</a><br><br>[I feel the need: the need for speed]<br><br><br>_______________________________________________<br>Valentina mailing list<br><a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br><a href="http://lists.macserve.net/mailman/listinfo/valentina">http://lists.macserve.net/mailman/listinfo/valentina</a><br></div></blockquote></div><br></div></div><div><div>_______________________________________________</div><div>Valentina mailing list</div><div><a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a></div><div><a href="http://lists.macserve.net/mailman/listinfo/valentina">http://lists.macserve.net/mailman/listinfo/valentina</a></div></div></div></span>
</blockquote>
<div>
<br>
</div>