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
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
pmscmd startworkflow -sv
how we can load rejected record's at run time?(not through bad files)
What is session task and command task?
How can you define user defied event?
What does update strategy mean, and what are the different option of it?
What is an aggregator transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is a connected transformation?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Target increases every day even though no new record was inserted
What do you understand by SOA of Informatica?
tell me about your project functionality
What are different types of transformations available in informatica?