Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6100 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to join three sources using joiner? Explain though mapping flow.
Quickly characterize reusable change?
have u done any performance tuning? how u ll do?
What is exclusive and normal mode for repository services?
How can a transformation be made reusable?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are mapplets? How is it different from a Reusable Transformation?
Can you use flat files in Mapplets.
How many dimensions are there in informatica?
What is flashback table ? Advance thanks
How to do the error handling of if ur source is flatfiles?
Differentiate between sessions and batches?
Define filter transformation?
What is sq transformation?
Can we get 1st record through Informatica(without sequence number).
