I have a column country with duplicate values. Wanted to remove duplicates from column . Please help me to write sql query to remove duplicate values ,Trim spaces in semicolon separate values and sor the countries.
Actual
Country
US; US; Australia
Australis;US; China;US; Australia
--------------------------------------
Expected
Country
Australia;US
Australia;China;US
Thank you.