how will you find out the last three records in a table
with n no of records and delete them
- 3 Answers
- 5047 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 are three advantages to using sql?
Can we call procedure in select statement?
How many sectors are in a partition?
What are the different types of database management systems?
What is package in pl sql with an examples?
What is over () in sql?
Difference between truncate, delete and drop commands?
What are sql built in functions?
Why join is faster than subquery?
How long does it take to learn pl sql?
What is the difference between between and in condition operators?
What is the difference between having clause and where clause?
What is the difference between inner join and outer join?
What does seeding a database mean?
How do I sort a table in sql?
