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
- 6234 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 the topics in pl sql?
what is a materialized view? : Sql dba
What are the different set operators available in sql?
What type of database is sql?
how many ways we can we find the current date using mysql? : Sql dba
how would you enter characters as hex numbers? : Sql dba
What is the most important ddl statements in sql are?
What are sql indexes?
Why truncate is used in sql?
What does closing a cursor do?
How do I debug a stored procedure?
how many tables will create when we create table, what are they? : Sql dba
What is inner join in sql?
What is sql used for?
What is sap sql?
