[SQL] 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

[SQL] weighting (the results of) a query ?

I have a table with a primary key ('md5') and a bunch of text fields. There is one row per 'photograph' and the number of rows is about 1100 now but will rise to over 20,000 in a few months - assuming I get time to import all my stuff. I would like to offer users on my web site a free text search

Re: [SQL] Deleting in order from a table

--- pginfo <[EMAIL PROTECTED]> 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. >