how will you find out the last three records in a table
with n no of records and delete them
- 3 Answers
- 5489 Views
- I also Faced
- E-Mail Answers
Answer Posted / aswin
This query cost the performance :
delete from emp where empno in (select empno from (select
empno from emp order by rowid desc) where rownum <= 3)
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
what is data control language? : Sql dba
What is varchar example?
What is PL/SQL Records?
How do you select unique values in sql?
What is record variable?
What is the starting oracle error number?
what is row? : Sql dba
What is the use of sqlerrd 3?
What are the advantages of sql? Explain
Which join is like an inner join?
Explain what is rdbms?
Is a table valued function object?
Explain what is a view?
Explain the the delete statements in sql?
Is a foreign key always unique?
