Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in particular
fields(columns) in different tables
- 6 Answers
- 13654 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / rajesh
DELETE emp WHERE ROWID NOT IN(SELECT MIN(eid)FROM emp GROUP
BY eid);
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What is parameter substitution in sql?
explain commit and rollback in mysql : sql dba
When you have to use a default "rollback to" savepoint of plvlog?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
what is the difference between char and varchar data types? : Sql dba
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
How to add new employee details in an employee_details table with the following details
what is sql? : Sql dba
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What are character functions in sql?
what does myisamchk do? : Sql dba
What is a database? Explain
Is pl sql still used?
Can you do multiple joins in sql?
What is user defined functions?
