how will you find out the last three records in a table
with n no of records and delete them
- 3 Answers
- 5495 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
What is a nested table in word?
How to convert comma separated string to array in pl/sql?
How many types of triggers are there in pl sql?
How do you write an inner join query?
what is the difference between a having clause and a where clause? : Sql dba
Is delete faster than truncate?
How do I access sql anywhere database?
How to read/write files from pl/sql?
How do I copy a table in sql?
What are packages in pl sql and also explain its advantages?
What is package in pl sql?
Are sql database names case sensitive?
Why do we use joins?
What are synonyms in sql?
Can you skip header records while loading? : aql loader
