delete from table_name where(rowid,0) in (select rowid,mod(rownum,2) from table_name) this is for alternate deleting even row
delete from table_name where (rowid,1)in(select rowid,mod(rownum,2)from table_name)this is for alternate deleting odd row
Chat with our AI personalities
The SQL order allows a result set with rows being sorted by the values of one or more columns. At the present time it is the only known way to sort the rows in the result. It will also prevent the database system fro returning the rows in any order.
33 desks can be arranged into six rows having no rows, 1 row, 2 rows, 3 rows, 4 rows, or 5 rows with exactly 5 desks.
Sparky had room for 16 rows in his garden He planted 3 rows of tomatoes for every 5 rows of onions He planted 10 rows of onions.
Sparky had room for 16 rows in his garden He planted 3 rows of tomatoes for every 5 rows of onions. 6 rows of tomatoes were planted.
Having the same number of students in each row, 80 students can be arranged in 80 rows of 1, 40 rows of 2, 20 rows of 4, 10 rows of 8, and 5 rows of 16.