这是一种方法（假设使用SQL2005或更高版本）。
With Ages As(select count(userID) ageCount,userBirthYear from Usersgroup by userBirthYear)SELECt ageCount,userBirthYear FROM Ages WHERe ageCount>5UNIOn ALLSELECt sum(ageCount) ,'others' As userBirthYear FROM Ages WHERe ageCount<=5
