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
- 6099 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
Explain what is a subquery ?
What is sql in java?
What is rank dense_rank and partition in sql?
How do I view output in sql developer?
How do you rename a table in sql?
Which is faster truncate or drop?
Which kind of parameters cannot have a default value in pl sql?
what is 'mysqlshow'? : Sql dba
What is an emotional trigger?
How do I filter in sql profiler?
Is pl sql still used?
What is an alias command?
Why use stored procedures?
give the syntax of grant and revoke commands? : Sql dba
how to convert numeric values to character strings? : Sql dba
