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
- 6233 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
Can we use view in stored procedure?
How is indexing done in search engines?
Why is %isopen always false for an implicit cursor?
What are the qualities of 2nf?
Why we use sql profiler?
How to rename a column in the output of sql query?
what is sp_pkeys? : Transact sql
What is the basic form of sql query?
Which is faster count (*) or count 1?
How many subqueries can be nested in a statement?
Explain the savepoint statement.
Define the select into statement.
Does group by remove duplicates?
How do you write an inner join query?
What does sign mean sql?
