can u tell me this sql querry

[center34]

hello can anybody help me

if there is a table named emp and there are 100 rows in this table and we like to delete 30 rows from the bottom .can any body help me with this SQL querry

[debasisdas]

try to use MINUS and rowid for the purpose.

[center34]

thanks but

can u please help me with this querry further,

[center34]

this is the combination which I do get

delete from emp
where rowid not in ( select rowid from emp minus select rowid from emp where rownum between 70 and100);

[center34]

thanks anyways

thanks anyways for this help