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

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);

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);

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..

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);

Answer / xyz

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

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..

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))

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;

Answer / ajith

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

in one report using two layout models.if yes how to do

2 Answers  

what is inbound and outbound interface?

2 Answers  

Except the SRS window in which we can submit the concurrent program.

5 Answers   IBM, TCS,

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

0 Answers  

What do you understand by concurrent programs?

0 Answers  

1) why we need to do Validations when the Standard Conc. Prog or the API will do all the validations 2) How can we display more then 1 column data in a formula column (Ex displaying Empno, Ename, sal data in one Formula column) 3) is it possible to give 2 out paramaters in a function

2 Answers   Zensar,

in order to run utl_file package we need to give any specific path? if yes what is that?where u will run utl_package?

1 Answers   KPMG,

while running a interface if we get 100 records as erors. how to debug it.

2 Answers   Zensar,

how to print multi lay outs,muti currency,muti language in xml publisher

2 Answers   Deloitte, Oracle,

what is meant by boilerplates?

1 Answers  

what are the different types of parameters avialable in reports?

2 Answers   Oracle,

what is mutating table and mutating error and how to solve that?

3 Answers