1. Categories >> Software >> ERP CRM >> Oracle Apps >> Oracle Apps Technical
  2. Suggest New Category

Write an SQL Query to
Delete Duplicate records from a table using ROWID.

Question Posted / murugaraj.g

Answer Posted / murugaraj.g

HERE COLUMN_NAME IN ( SELECT COLUMN_NAME FROM TABLE D
WHERE D.COLUMN_NAME_1=E.COLUMN_NAME_1
MINUS
SELECT COLUMN_NAME FROM TABLE F
WHERE F.COLUMN_NAME_1 = E.COLUMN_NAME_1
AND ROWNUM = 1);

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the concept of soa governance?

776

what is global tempory table?

6313

please send me forms, xml pulisher questions,answers

1658

tell me the scenarios of the independent in reports

2110

what are the balancing segments in AR?

1653




How can a process be deployed in soa?

700

Can we create tables in apps schema?

622

Explain oracle apps architecture.

767

Tell me how to debug the report?

642

Can u give the Documentation of Custom.pll in oracle apps

2998

How can we import the data into a database using sql * loader?

682

What is instead of trigger in where we will use?

680

how do you describe O2C along with tables

2313

Can you define an erp system?

682

How to move the one file from one instance to another instance? And your scripts also?

617