Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 9069 Views
- Bank Of America, I also Faced
- E-Mail Answers
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
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is the difference between informatica 7.0 and 8.0?
What is meant by target load plan?
How do you update the records with or without using update strategy?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What are the tasks that can be performed using sq?
What is the Rank index port in Rank transformation?
What is the way to execute pl/sql script using informatica mapping?
What is the status code in stored procedure transformation?
What are the transformations that are not supported in mapplet?
How to Create a folder using pmrep command?
Enterprise data warehouse your projects phase by phase explain?
How you prepared reports for OLAP?
