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
- 6113 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
Why do we need view in sql?
What is a relationship and what are they?
Explain the order of sql statement execution?
explain access control lists. : Sql dba
Is sql low level language?
what are date and time data types in mysql? : Sql dba
How do you update a value in sql?
What are transaction and its controls?
How show all rows in sql?
how do you login to mysql using unix shell? : Sql dba
How do you use join?
What is the use of double ampersand (&&) in sql queries? Give an example
What is difference between hql and native sql?
What is a join query?
How to get list of all tables from a database?
