求SQL语句下表中包含BB的参数2,3,4求和并输出结果?

[qq_21532693]

求大神..

[刘蕘]

select  sum(rank_2), sum(rand_3), sum(rand_4) #参数2-4
FROM Test1
where rank_1 like '%bb%';

[AHUA1001]

select 'BB' 参数1, sum(参数2) 参数2, sum(参数3) 参数3, sum(参数4) 参数4
FROM table_name
where 参数1 like '%BB%';