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
- 6115 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
What is informatica powercenter repository?
What are the limitations of joiner transformation?
How to implement security measures using repository manager?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Quickly characterize reusable change?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How many ways are there to do 'remove duplicate records in informatica'?
How can we use batches?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Repository user profiles
What is resilience time?
Explain pmcmd command usage in informatica
What is rank index in rank transformation?
Describe expression transformation?
What are the issues you have faced in your project? How did you overcome those issues?
