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
- 5596 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / nagarau puppala
select distinct country_id "unique", (case when count(country_id) > 1 then country_id else null end) "duplicate" from s_region
group by country_id order by duplicate;
| Is This Answer Correct ? | 3 Yes | 4 No |
how to move the mappings from your local machine to claint place?
What are connected or unconnected transformations?
How we can create indexes after completing the load process?
In a table, 4 person having same salary. How to get Third person record only?
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
explain different types of modeling.
What is the reusable transformation?
i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500
What is primary and backup node?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
Difference between Target-based loading and constraint-based loading?
Teradata 
