how will you find out the last three records in a table
with n no of records and delete them
- 3 Answers
- 5488 Views
- I also Faced
- E-Mail Answers
Answer Posted / sudipta santra
delete from
(select * from tab1
minus
select * from tab1 where rownum<n-2 order by rowid)
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
what is a constraint? : Sql dba
Can you load data into multiple tables at once? : aql loader
What is the purpose of the sql select top clause?
Which join condition can be specified using on clause?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What are pl sql procedures?
How do I create a memory optimized filegroup?
What is trigger price?
What is using in sql?
Can we rename a column in the output of sql query?
What are the different sql commands?
Can two tables have same primary key?
how to fetch alternate records from a table? : Sql dba
Which software is used for pl sql programming?
Is a secondary key the same as a foreign key?
