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
- 5967 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
How does sql*loader handles newline characters in a record? : aql loader
how to get a list of all tables in a database? : Sql dba
What are triggers and its types?
What is sqlservr exe?
Explain the uses of database trigger.
What is where clause in sql?
What is oracle pl sql developer?
How is a process of pl/sql compiled?
what is 'mysqlshow'? : Sql dba
What is use of package in pl sql?
What is the difference between inner join and outer join?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What is the use of primary key?
What are the sql aggregate functions?
When should I use nosql database?
