how will you find out the last three records in a table
with n no of records and delete them
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 types in sql?
Enlist the data types that can be used in pl/sql?
What are the different dml commands in sql?
What is offset and limit in sql?
What does closing a cursor do?
what are the advantages and disadvantages of views in a database? : Sql dba
What is embedded sql what are its advantages?
Is sql procedural language?
What is Histogram?
what are the differences between require and include, include_once and require_once? : Sql dba
What is the use of desc in sql?
What is dbo in sql?
Can a key be both primary and foreign?
What is pl/sql table? Why is it used?
How can we link a sql database to an existing android app?