Re: Deleting in order from a table

--- pginfo <pginfo(at)t1(dot)unisoftbg(dot)com> wrote:
> I have a table tableA ( ....,order_num int).
>
> I will to delete some records from tableA but in asc
> or desc
> order_num-order.
>
> Is it possible to write delete from tableA where
> (some conditions) order
> by order_num ?
>
> Many thanks,
> ivan.
>

Try the following:

DELETE
FROM tableA
WHERE order_num IN (
SELECT order_num
FROM tableA
ORDER BY order_num
LIMIT n OFFSET m);

Use LIMIT to determine the number of rows to delete
and OFFSET to determine the "starting row".

ludwig

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com