解决方案 »
- 请问该sql该如何处理好 ?
- mysql4.0.25升级成4.1.22,数据插入的问题.
- 超急::给mysql打ipv6 enabled补丁后,通过它的C API连接的诡异问题
- 谁帮我翻译成mysql的语句
- 如何在MySQL中保存的不同的文件类型
- 远程连接一台redhat 8.0机器中的mysql出现的问题
- mysql控制中心(windows)的能不能恢复数据库啊??
- 在mysql中用tinyint 类型做主关健字的类型长度为4,并且默认值为autoincreatment
- 能否详细的介绍一下 mySQL 的特性,大虾请进!!!!!!!
- 大神帮忙看看数据库还原的问题
- 又是一个关于索引的小问题
- 求一条sql语句
case
when price between 0 and 3 then 1
when price between 3 and 6 then 2
when price between 6 and 10 then 3
end,
count(*)
from 我有一个表A
group by case
when price between 0 and 3 then 1
when price between 3 and 6 then 2
when price between 6 and 10 then 3
end
select
case
when price between 0 and 3 then 1
when price between 3 and 6 then 2
when price between 6 and 10 then 3
end,
count(*)/(select count(*) from 我有一个表A)
from 我有一个表A
group by case
when price between 0 and 3 then 1
when price between 3 and 6 then 2
when price between 6 and 10 then 3
end