sql查询将不同的项目分组到存储桶中

Kerrek所描述的扩展选项，您可以根据案例/时间进行分组

select      case when price >= 0 and price <= 10    then '  0 - 10'when price > 10 and price <= 50   then ' 10+ - 50'when price > 50 and price <= 100  then ' 50+ - 100'else 'over 100'      end PriceRange,      count(*) as TotalWithinRange   from      YourTable   group by 1

此处，“ group by 1”表示您的select语句中的序号列…在这种情况下，为case / when为TotalWithinRange时。