I have a table called Product. It has column called colors. It contains data as follows:
The data type for colors is varchar
. The database contains large product values (almost 2 hundred) , and same applies to colors. Now I need to write an sql query script to find top 2 products having largest variation in colors.