write a query for how to eliminate the duplicate rows without using distinct?

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

write a query for how to eliminate the duplicate rows
without using distinct?

Question Posted / sree

6 Answers
12362 Views
iGate, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write a query for how to eliminate the duplicate rows without using distinct?..

Answer / mani

DELETE FROM EMP WHERE ROWID NOT IN (SELECT MAX(ROWID)FROM
EMP)GROUP BY EMPNO;

Is This Answer Correct ?

10 Yes

2 No

write a query for how to eliminate the duplicate rows without using distinct?..

Answer / madhu

DELETE FROM EMP WHERE ROWID NOT IN (SELECT MAX(ROWID)FROM
EMP GROUP BY EMPNO);

Is This Answer Correct ?

6 Yes

0 No

write a query for how to eliminate the duplicate rows without using distinct?..

Answer / abhishek kumar

select id from tgt_table group by id;

Is This Answer Correct ?

7 Yes

4 No

write a query for how to eliminate the duplicate rows without using distinct?..

Answer / czarabid

it's very simple the question is to delete the duplicated
records and it's solution is here
DELETE FROM TABLE_NAME1 t1 WHERE ROWID </> any(SELECT ROWID
FROM TABLE_NAME1 t2 WHERE t1.column1=t2.column1);
this will delete only the redundant records leaving only one
copy of the same records in the table.
If you want to delete all the records which are redundant
then the solution is here
DELETE from table_name1 t1 where rowid <> any (select rowid
from table_name1 t2 where t1.no=t2.no)

Is This Answer Correct ?

0 Yes

0 No

write a query for how to eliminate the duplicate rows without using distinct?..

Answer / murali udayagiri

Assume some duplicate data is there in emp table. Try the
below to eliminate duplicate.

select * from emp
union
select * from emp;

Thanks,
Murali Udayagiri

Is This Answer Correct ?

2 Yes

5 No

write a query for how to eliminate the duplicate rows without using distinct?..

Answer / bharu_295

select count(*),col1,col2 ..... from table_name
groupby col1,col2.....
having count(*)>1

Is This Answer Correct ?

2 Yes

9 No

Post New Answer