Interested to Buy Any Domain ? << Click Here >> for more details...
how will you find out the last three records in a table
with n no of records and delete them
- 3 Answers
- 6104 Views
- I also Faced
- E-Mail Answers
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
How to move files from one directory to another in pl sql?
What is the purpose of the primary key?
Which function is used to return remainder in a division operator in sql?
What is schema in sql?
Do ddl statements need commit?
What is a null value?
What's the procedure?
How do I find duplicates in sql?
What is auto increment in sql?
What is the process of debugging?
what are the features and advantages of object-oriented programming? : Sql dba
Why do you partition data?
How do I restart sql?
What packages are available to pl/sql developers?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
