delete from (select * from tab1 minus select * from tab1 where rownum

how will you find out the last three records in a table
with n no of records and delete them

Question Posted / sudipta santra

Answer Posted / sudipta santra

delete from
(select * from tab1
minus
select * from tab1 where rownum<n-2 order by rowid)

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Are sql connections encrypted?

1029

Is foreign key mandatory?

1005

What will you get by the cursor attribute sql%found?

963

Does sql profiler affect performance?

994

What will you get by the cursor attribute sql%rowcount?

1038

does sql support programming? : Sql dba

1050

What are some emotional triggers?

985

What is an oracle stored procedure?

1053

how to calculate expressions with sql statements? : Sql dba

1034

Explain some predefined exceptions.

1039

How do you optimize a stored procedure in sql?

957

What is trigger and how to use it in sql?

1021

What is number function in sql?

975

How do I send sql query results to excel?

1066

What has stored procedures in sql?

1066