疑难点一是要分类统计的区间是一个字符串,例如“0-60” ,还有就是这个分类不是固定分成几类,区间值也不确定常量表param:
id param_value paramclass_id1 0-60 112 60-100 113 100-300 11要被统计的表roomid mianji 1 592 403 236最后想要统计的效果count param_value
2 0-60
0 60-100
1 100-300
想了一天没想出来,请高手帮忙!
id param_value paramclass_id1 0-60 112 60-100 113 100-300 11要被统计的表roomid mianji 1 592 403 236最后想要统计的效果count param_value
2 0-60
0 60-100
1 100-300
想了一天没想出来,请高手帮忙!
- 之后 right(列,len(列)-charindex('-',列))
from tb1 join tb2 on mianji between cast(left(param_value ,charindex('-',param_value )-1) as int) and cast(right(param_value ,len(param_value )-charindex('-',param_value )) as int)
group by param_value