--照着这个改一下就可以了 select number, case when (max_count between 1 and 49) then 5 when (max_count between 6 and 10) then 3 else 1 end from testcasewhen
要获取价格的话再价格where 价格的条件
你有两个price列用别名区分一样呢,然后#1思路是可以的。
select id, case when (price between 1 and 5) then '1-4' when (price between 6 and 10) then '6-10' else '>10' end as 数量, case when (price between 1 and 5) then 5 when (price between 6 and 10) then 3 else 1 end from testcasewhen id 数量 (无列名) 1 1-4 5 1 6-10 3 1 >10 1
--照着这个改一下就可以了
select number, case
when (max_count between 1 and 49)
then 5
when (max_count between 6 and 10)
then 3 else 1 end
from testcasewhen
select id, case
when (price between 1 and 5)
then '1-4'
when (price between 6 and 10)
then '6-10' else '>10' end as 数量, case
when (price between 1 and 5)
then 5
when (price between 6 and 10)
then 3 else 1 end
from testcasewhen
id 数量 (无列名)
1 1-4 5
1 6-10 3
1 >10 1