Subject Re: Help..... Need Delete first 10 records .....
Author mailmur
>> Need Delete first 10 records a Table.
>> 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.

I think he already knows _his_ 10 first records, its irrelevant what
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.