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
- 6058 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 call shell script from pl sql procedure?
What is a ddl command?
What is a record in a database?
What are the different dcl commands in sql?
How do I find duplicates in two columns?
How does sql store data?
How does one load ebcdic data? : aql loader
How to use transactions efficiently : transact sql
What is a scalar value in sql?
What are the various restrictions imposed on view in terms of dml?
Can we perform dml on view?
How to run sql statements through the web interface?
What is procedure in pl sql?
What are different types of sql commands?
What is data abstraction in sql?
