write a query for how to eliminate the duplicate rows
without using distinct?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
Answer / bharu_295
select count(*),col1,col2 ..... from table_name
groupby col1,col2.....
having count(*)>1
Is This Answer Correct ? | 2 Yes | 9 No |
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
what is hash table in informatica?
what is difference between COM & DCOM?
wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15
What is joiner cache?
What is log file,and where is it located,why u r using the log file
how can we run workflow with pmcmd?
How to recover the standalone session?
What is the function of union transformation?
What is a pre-defined event and user-defined event?
write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?