write a sql query following table some duplicate present
1
1
2
2
3
3
4
5
i want the output unique one column duplicate another
column following format like
unique duplicate
1 1
2 2
3 3
4
5
- 2 Answers
- 4881 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / babu
Hi,
SELECT DISTINCT(DEPTNO) UNIQ,E.DUP FROM EMP
LEFT OUTER JOIN
(SELECT DEPTNO DUP FROM EMP GROUP BY DEPTNO HAVING COUNT
(DEPTNO)>1) E
ON (EMP.DEPTNO=E.DUP)
please correct me if any thing wrong.
Thanks,
Babu
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What do you mean by filter transformation?
What is Index Caches size?
Briefly define reusable transformation?
How do you load alternate records into different tables through mapping flow?
How many number of sessions can one group in batches?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
lookup transformation with screenshots
How do you handle two sessions in Informatica
What is expression transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
what is $$$$?
Plz can any one say me how to get the informatica certification materials and dumps
What is informatica?
What is xml source qualifier transformation in informatica?
What is target load order?
