Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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


Please Help Members By Posting Answers For Below Questions

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1456


how we can load rejected record's at run time?(not through bad files)

2325


What is session task and command task?

1206


How can you define user defied event?

988


What does update strategy mean, and what are the different option of it?

1055


What is an aggregator transformation?

1039


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2086


What is a connected transformation?

1062


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?

1015


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2294


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?

1113


Target increases every day even though no new record was inserted

1524


What do you understand by SOA of Informatica?

936


tell me about your project functionality

2309


What are different types of transformations available in informatica?

949