Interested to Buy Any Domain ? << Click Here >> for more details...
Delete duplicate records in the emp table.
- 6 Answers
- 14569 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / valli
delete from emp where rowid in(
select rowid from (
select emp_no, sal,rownum() over (emp_no,sal) as
Rownum from emp order_by emp_no,sal
) where rownum > 2
)
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
How do I send sql query results to excel?
How is pl sql different from sql?
What is orm in sql?
What do you mean by stored procedures?
discuss about myisam key cache. : Sql dba
What is embedded sql in db2?
What do you mean by stored procedures? How do we use it?
What is latest version of sql?
What will you get by the cursor attribute sql%found?
Can we commit inside a trigger?
Explain normalization and what are the advantages of it?
explain commit and rollback in mysql : sql dba
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 are the types of subquery? : Sql dba
How is data stored on a disk?
