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
- 6235 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 different sql data types?
How to Declare Fixed Length String Value In PL SQL
What's the difference between a primary key and a clustered index?
What is left inner join in sql?
What is the use of <> sql?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
What is latest version of sql?
What is embedded sql what are its advantages?
How do I write a cron which will run a sql query and mail the results to agroup?
What is the difference between delete, truncate and drop command?
What is a full join sql?
Can we create index on primary key?
What are basic techniques of indexing?
how many sql ddl commands are supported by 'mysql'? : Sql dba
How many types of primary keys are there?
