一个sql查询如何返回多个结果?

[lasker]

例如:
select sum(price) from table where month = 1;//查询一月的营业额
我如果想返回：１－６月，每个月的营业额应该怎么写语句？
我不想查６次！

[milozy1983]

selet sum(price) from table group by month

[iuhxq]

selet sum(price) from table group by month where month between (1 and 6)

[xiao_deng]

selet sum(price) from table group by month where month in(1,2,3,4,5 6)