从数据库中按分数段查询人数

2009-08-18 11:48:01 473 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

保姆级教程：在Ubuntu 20.04上从零跑通AT128雷达实时点云（附PandarView 2安装避坑指南）本文提供了一份详细的Ubuntu 20.04系统下AT128雷达实时点云配置教程，涵盖环境准备、脚本修改、PandarView 2安装及常见问题排查。通过逐步指导，帮助开发者解决权限、网络配置等难题，确保顺利实现雷达数据的实时可视化。特别附有PandarView 2安装避坑指南，适合新手快速上手。阅读详情

MS_SQL Server
要求显示结果如下:

分数段人数
<60 XX
60~69 XX
70~79 XX
80~89 XX
90~99 XX
100 XX

...全文

cadence Virtuoso ADE原理图库中的VCVS（压控电压源）使用 Symbol: vcvs (Voltage Controlled Voltage Source) Vop−Von=egain⋅(Vip−Vin)V_{op}-V_{on}=egain\cdot(V_{ip}-V_{in})Vop−Von=egain⋅(Vip−Vin) 所以可以得出 ⟹Vop=egain⋅(Vip−Vin)+Von\Longrightarrow V_{op}=egain\cdot(V_{ip}-V_{in})+V_{on}⟹Vop=egain⋅(Vip−Vin)+Von 使阅读详情

王可诚

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

gxjwqm 2009-08-19

打赏
举报

[Quote=引用 7 楼 feixianxxx 的回复:]
SQL codeselect 分数段='[100]',count(*)as 个数from tbwhere 分数=100unionallselect 分数段='[90~99]',count(*)as 个数from tbwhere 分数between90and99unionallselect 分数段='[80~89]',count(*)as 个数from tbwhere 分数between80and8¡
[/Quote]

--小F-- 2009-08-18

打赏
举报

[Quote=引用 2 楼 wufeng4552 的回复:]
SQL codeselectsum(casewhen 分数<60then1else0end )[<60],sum(casewhen 分数between60and69then1else0end )[60~69],sum(casewhen 分数between70and79then1else0end )[70~79],sum(casewhen 分数between80and89then1else0end ¡
[/Quote]

水哥正解

水族杰纶 2009-08-18

打赏
举报

select sum(case when 分数<60 then 1 else 0 end )[<60],

       sum(case when 分数 between 60 and 69 then 1 else 0 end )[60~69], 

       sum(case when 分数 between 70 and 79 then 1 else 0 end )[70~79],

       sum(case when 分数 between 80 and 89 then 1 else 0 end )[80~89],

       sum(case when 分数 between 90 and 99 then 1 else 0 end )[90~99],

       sum(case when 分数=100 then 1 else 0 end )[100]

from tb

SQL77 2009-08-18

打赏
举报

SELECT 分数段,

SUM(CASE WHEN 分数<60 THEN 1 ELSE 0)AS  人数..

SUM(CASE WHEN 分数<60 THEN 1 ELSE 0)AS  人数..

SUM(CASE WHEN 分数<60 THEN 1 ELSE 0)AS  人数..





FROM TB

水族杰纶 2009-08-18

打赏
举报

[Quote=引用 13 楼 fredrickhu 的回复:]
引用 12 楼 wufeng4552 的回复:
嵌套多余
影响效率~~~

我是用来oder by 的
[/Quote]
不须order by
它会按照union all
的顺序排列的

--小F-- 2009-08-18

打赏
举报

[Quote=引用 12 楼 wufeng4552 的回复:]
嵌套多余
影响效率~~~
[/Quote]

我是用来oder by 的

水族杰纶 2009-08-18

打赏
举报

嵌套多余
影响效率~~~

--小F-- 2009-08-18

打赏
举报

select * from

(

 select  分数段 = '<60' , count(1) as 人数 from tb 

 union all

 select  分数段 = '60~69' , count(1) as 人数 from tb

 union all

 select  分数段 = '70~79' , count(1) as 人数 from tb

 union all

 select  分数段 = '90~99' , count(1) as 人数 from tb

 union all

 select  分数段 = '100' , count(1) as 人数 from tb



) t

order by  case when 分数<60 then 1 

          case when 分数 between 60 and 69 then 2 

          case when 分数 between 70 and 79 then 3 

          case when 分数 between 80 and 89 then 4 

          case when 分数 between 90 and 99 then 5

          case when 分数=100 then 6 end

水族杰纶 2009-08-18

打赏
举报

...

--小F-- 2009-08-18

打赏
举报

select * from

(

 select  分数段 = '<60' , 分数 = 语文,人数 from tb 

 union all

 select  分数段 = '60~69' , 分数 = 数学,人数 from tb

 union all

 select  分数段 = '70~79' , 分数 = 物理,人数 from tb

 union all

 select  分数段 = '90~99' , 分数 = 数学,人数 from tb

 union all

 select  分数段 = '100' , 分数 = 物理,人数 from tb



) t

order by  case when 分数<60 then 1 

          case when 分数 between 60 and 69 then 2 

          case when 分数 between 70 and 79 then 3 

          case when 分数 between 80 and 89 then 4 

          case when 分数 between 90 and 99 then 5

          case when 分数=100 then 6 end

黄_瓜 2009-08-18

打赏
举报

select * from

(

select 分数段='[100]',count(*) as 个数 from tb where 分数=100

union all

select 分数段='[90~99]',count(*) as 个数 from tb where 分数 between 90 and 99

union all

select 分数段='[80~89]',count(*) as 个数 from tb where 分数 between 80 and 89 

union all

select 分数段='[70~79]',count(*) as 个数 from tb where 分数 between 70 and 79 

union all

select 分数段='[60~69]',count(*) as 个数 from tb where 分数 between 60 and 69 

union all

select 分数段='[<60]',count(*) as 个数 from tb where 分数<60

)

feixianxxx 2009-08-18

打赏
举报

select 分数段='[100]',count(*) as 个数 from tb where 分数=100

union all

select 分数段='[90~99]',count(*) as 个数 from tb where 分数 between 90 and 99

union all

select 分数段='[80~89]',count(*) as 个数 from tb where 分数 between 80 and 89 

union all

select 分数段='[70~79]',count(*) as 个数 from tb where 分数 between 70 and 79 

union all

select 分数段='[60~69]',count(*) as 个数 from tb where 分数 between 60 and 69 

union all

select 分数段='[<60]',count(*) as 个数 from tb where 分数<60

feixianxxx 2009-08-18

打赏
举报

[code=SQL]

select 分数段='[100]',count(*) as 个数 from tb where 分数=100

union all

select 分数段='[90~99]',count(*) as 个数 from tb where 分数 between 90 and 99

union all

select 分数段='[80~89]',count(*) as 个数 from tb where 分数 between 80 and 89 

union all

select 分数段='[70~79]',count(*) as 个数 from tb where 分数 between 70 and 79 

union all

select 分数段='[60~69]',count(*) as 个数 from tb where 分数 between 60 and 69 

union all

select 分数段='[<60]',count(*) as 个数 from tb where 分数<60

[/code]

王可诚 2009-08-18

打赏
举报

（竖着排列）

王可诚 2009-08-18

打赏
举报

期待完美答案中。。。。。。。。。（坚着排列）

从数据库中按分数段查询人数

相关推荐