I have a query that i'm using to retrieve the counts of certain data, the problem is that I want to display two of the values and the others I would like to group them into an other group and have there counts combined. This is the statement I have so far.
select colA, colB, count(colA)
group by colA,colB;
The statements gives all the values of colA but I would only like to see 2 values and the rest I would like to see them combined, with the name other assigned to the combined values.