how will you find out the last three records in a table
with n no of records and delete them
Answer Posted / ajit
delete from emp
where empno in
(select empno
from emp
minus
select empno
from emp
where rownum <= ( select count(*) - 3
from emp
))
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What programs use sql?
what are the differences among rownum, rank and dense_rank? : Sql dba
Can we call a function containing dml statements in a select query?
What is pl sql and why it is used for?
What is dbo in sql?
Explain the update statement in sql
What is varray in pl sql?
Can you have more than one key in a database?
what is the stuff function and how does it differ from the replace function? : Sql dba
What are the uses of merge?
How to make a copy values from one column to another in sql?
What is dba in sql? : SQL DBA
What is int identity in sql?
What is the benefit of foreign key?
What is dcl in sql?