| Subject | Re: [ib-support] Delete first 100 from table |
|---|---|
| Author | Markus Ostenried |
| Post date | 2003-06-10T20:34:14Z |
At 14:59 Tuesday, 10.06.2003 -0500, you wrote:
I guess you could something like
DELETE FROM YourTable
WHERE YourField IN
(
SELECT FIRST 100 YourField FROM YourTable
WHERE <your Condition>
);
HTH,
Markus
>Is there a way to delete the first so many records like you can do in aHi Don,
>select?
I guess you could something like
DELETE FROM YourTable
WHERE YourField IN
(
SELECT FIRST 100 YourField FROM YourTable
WHERE <your Condition>
);
HTH,
Markus