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 / anto
unique
select distinct name,id from table
duplicate
select name,id from table
group by name,id
having count(name||id) > 1
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Reusable transformation and shortcut differences
Where do we use mapping variables in informatica?
What is data movement mode in Informatica and difference between them?
What is data caches/ index caches?
What is joiner change?
How to configure mapping in informatica?
Can anyone tell me the new features in Informatica 9 Version?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is fact table? Explain the different kinds of facts.
What is the Process to creating lookup transformation in informatica
difference between informatica 8.1.1 and 8.6
What is a snowflake schema?
what is the difference between informatica6.1 and infomatica7.1
Explain why we use partitioning the session in informatica?
What is InformaticaPowerCenter?