Can anyone explain how to prioritize data for the below example. The logic must be ,
ID COUNTRY
1 India
2 Australia
3 Germany
If India ,Australia and Germany is present for a particular id then only India must be displayed .and if India and Germany is present for particular id then India must be displayed Similarly if Australia and Germany is present for particular id then Australia must be displayed and if Australia and India is present for particular id then India must be displayed .
Can anyone please help in resolving the above scenario..
