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
- 8776 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
how we can load rejected record's at run time?(not through bad files)
What is the Process to creating lookup transformation in informatica
What is the reusable transformation?
How many transformations can be used in mapplets.
What is main use of mapplet?
Is there any way to read the ms excel datas directly into informatica?
What is an expression transformation in informatica?
Explain what are the different versions of informatica?
Explain sessions?
expain about the tune parameters?
Explain pmcmd command usage in informatica
Separate from a database, an information bazaar, and an information stockroom?
What is an aggregator transformation?
What are multi-group transformations?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
