I have this following that I need to roll to "Chinese" only and take a count of all these 3 Chinese languages:
so my desired output is one row as follows:
Chinese as PrimaryLanguage and 900 as Total count. The rest of the list contains a lot of other languages that I don't need to roll.
Thanks in advance.
case when primaryLanguage like 'Chinese%' then 'Chinese' else primaryLanguage end
© 2016 Powered by mzan.com design MATCHINFO