write s sql query following table some duplicate present i
want unique one column duplicate another column display?
name id
a 1
a 1
b 2
b 2
c 3
i want the required output like
unique duplicate
name id name id
a 1 a 1
b 2 b 2
c 3
Answer Posted / senthil
select a.nameid as unique_name_id,b.nameid as DUplicate_name_id
from
(select distinct nameid from name) a
left outer join
(select nameid from name group by nameid having count(*) > 1) b
on a.nameid = b.nameid
Output:
---------
unique_name_id Duplicate_name_id
a 1 a 1
b 2 b 2
c 3
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
If informatica has its scheduler why using third party scheduler?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is joiner transformation?
tell me the rules and responsblites in our project(my project is development)
Difference between Data and Index Caches?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are the differences between joiner transformation and source qualifier transformation?
How many input parameters can exist in an unconnected lookup?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is deployment group?
Explain in detail scd type 2 through mapping.
What is the use of target designer?
What is standalone command task?
What is exclusive and normal mode for repository services?