How will you delete a particular row from a Table?
Answer Posted / rakesh
delete from emp e1
where n = (select count(distinct rowid)
from emp e2
where e2.rowid <= e1.rowid)
Note:Here "n" means Nth row..
Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What is a loop in sql?
Do we need commit after truncate?
What are the query optimization techniques?
What port does sql server use?
What is sql and db2?
What is pl sql in oracle?
what are all the different normalizations? : Sql dba
What is pivot query?
What is the most common sql injection tool?
What is indexes?
what are all the different types of indexes? : Sql dba
What is a data manipulation language?
What does sql stand for?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
What are different types of triggers?