How to get top 50 countries and leave the rest of the countries grouped to others in MS sql server : I would like to see TOP 50 countries, remaining countries need to be grouped as other countries using CASE statement. IS that possible to do. Please suggest.