Interested to Buy Any Domain ? << Click Here >> for more details...
How will you delete a particular row from a Table?
- 7 Answers
- 16741 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
How do you explain an index number?
What is normalization in a database?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What is pl sql block structure?
Can two tables have same primary key?
What is count * in sql?
How run sql*plus commands that are stored in a local file?
Is sql microsoft?
what is a composite primary key ? : Sql dba
What is sql*plus?
Is sql a scripting language?
How many types of sql are there?
How do I view an execution plan in sql?
What is a string data type in sql?
What is the use of sqlerrd 3?
