Subject | Re: Help..... Need Delete first 10 records ..... |
---|---|
Author | mailmur |
Post date | 2004-12-25T12:07:30Z |
>> Need Delete first 10 records a Table.I think he already knows _his_ 10 first records, its irrelevant what
>> some idea of like doing it..!!!
> Well, start defining what the "first 10 records" are...
> Records don't have a particular order in a table.
kind of the OrderBy clause is using.
I dont know if Firebird supports inner query in a delete query. Here
is an idea which works in several db engines:
Delete From tTable
Where uniqueId in (Select TOP 10 uniqueId From tTable Order By editDate)
Change it to Firebird "Select FIRST 10 SKIP 0 ..." format for top
queries, but at the moment cannot test whether can use inner query in
delete syntax.