Thread: Deleting in order from a table
Hi , I think the question is stupied, but it is importand for me. 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.
--- pginfo <pginfo@t1.unisoftbg.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 LIMITn 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