Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Answers were Sorted based on User's Feedback



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

Answer / ravi kant yadav

Delete from table_name where ROWID not in ( select
max(rowid) from table group by duplicate_values_field_name);

Regards
ravi

Is This Answer Correct ?    2 Yes 0 No

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

Answer / amit shrivastava

Delete from table where rowid not in (select max(rowid)from
table group by column_name);

Delete from table T1 where rowid < (select min(rowid) from
table T2 where T1.emp_name=T2.emp_name);

Is This Answer Correct ?    4 Yes 3 No

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

Answer / 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

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

Answer / parthasarathi

delete T1
from MyTable T1, MyTable T2
where T1.dupField = T2.dupField
and T1.uniqueField > T2.uniqueField ;


Try this will work for SQL Server and My Sql but not for
MSAccess .....

For MSAccess try the below one

delete from MyTable
where uniqueField not in
(select min(uniqueField) from MyTable T2
where T2.dupField=MyTable.dupField);

The above query also works for SqlServer but not for MySql..

Is This Answer Correct ?    1 Yes 1 No

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

Answer / parthasarathi

delete tab1 where (col1_dup,rowid) in (select
col1_dup,max(rowid) from tab1 where group by col1_dup having
count(col1_dup)>1);

Is This Answer Correct ?    0 Yes 0 No

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

Answer / xyz

delete from emp where rowid not in(select max(rowid) from
emp group by empno)

Is This Answer Correct ?    0 Yes 0 No

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

Answer / bharath

1.SELECT ROWID FROM TABLE T1
WHERE ROWID NOT IN (SELECT MIN(ROWID)
FROM TABLE T2 WHERE T1.KEY=T2.KEY);

THIS QUERY IS USEFUL WHEN WE HAVE A KEY VAL.
2.
i.CREATE TABLE NEW AS SELECT DISTINCT * FROM OLD;
ii.DROP TABLE OLD;
iii.RENAME NEW TO ORIGINAL;
THIS IS WHEN WE APPLY TO DELETE DUPLICATE ROWS..

Is This Answer Correct ?    0 Yes 0 No

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

Answer / ankit kumar srivastava

DELETE FROM EMP_a WHERE ROWID NOT IN(
(SELECT MAX(ROWID) FROM EMP_a a GROUP BY
EMPNO,ENAME,sex,doj,sal,deptno,mgr HAVING COUNT(ROWID)
=1)
UNION
(SELECT MAX(ROWID) FROM EMP_a a GROUP BY
EMPNO,ENAME,sex,doj,sal,deptno,mgr HAVING COUNT(ROWID)>1))

Is This Answer Correct ?    0 Yes 0 No

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

Answer / srinivas

delete from emp where rowid not in(select max(rowid) from
emp group by sal);
and
delete from(select distinct sal from emp) where rowid>=1;

Is This Answer Correct ?    0 Yes 0 No

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

Answer / ajith

DELETE FROM EMP E1
WHERE E1.ROWID>(SELECT MIN(E2.ROWID)
FROM EMP E2
WHERE E1.EMPNO=E2.EMPNO)

Is This Answer Correct ?    0 Yes 0 No

Post New Answer



More Oracle Apps Technical Interview Questions

what is tuning in oracle apps technical

3 Answers   TCS,


Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

0 Answers  


Difference between triggers and procedures?

2 Answers  


Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

0 Answers  


what is flexfield qualifier?

3 Answers  






While running the concurrent program we will get the status, we have to change the status. How it will be done.

2 Answers   Zensar,


how many groups we can create for query?

3 Answers  


what is pay run id ?

0 Answers  


If the flat file is having the duplicate records in the interface how can you restrict while transferring the flat file data in to interface tables?

3 Answers   Accenture,


how to call report from oracle oracle apps11i?

3 Answers   Genpact,


where we will put the control file ,where we will run sql star loader what is the cmd?

1 Answers   Cap Gemini, KPMG,


There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.

3 Answers   Satyam,






Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (791)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)