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
- 6123 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 are character functions?
What is a primary key sql?
What is data type in database?
What is sql used for?
How do I sort a table in sql?
What does count (*) do in sql?
what is normalization? : Sql dba
Which is better join or inner query?
What is an inconsistent dependency?
Can unique keys be null?
What is trigger in sql? Explain
what are the nonstandard string types? : Sql dba
what are the differences between char and varchar? : Sql dba
What is the least restrictive isolation level? : Transact sql
Why is nosql good?
