请问怎么实现这个功能?

2006-12-31 02:47:08 247 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

机器学习生产化：模型上线后的系统韧性与防御设计机器学习模型部署不是开发终点，而是系统工程的真正起点。从数据血缘、特征一致性到延迟预算、熔断降级，生产环境中的ML系统需具备可观测性、可扩展性与可恢复性。本文聚焦模型上线后72小时内的高频故障——如特征延迟雪崩、重试导致重复决策、类型隐式转换错误等，结合混沌工程验证、SLO驱动告警、强类型校验与统一决策Schema等实战方案，系统阐述如何构建具备业务韧性的AI服务。内容覆盖金融、支付、风控等对延迟与可靠性敏感的关键场景，强调‘模型即服务’的责任迁移本质。阅读详情

假如我有这样一个表, 有两列: A, B. 都为int型

A B
1 4
3 6
4 6
...

我想实现统计A列, 统计条件是 0=< C<=1 , 3=<D<=4, 现在要统计A列中符合C, D条件的值, 并把符合C,D条件对应的B列和求出来, 结果类似如下:
result r_sum
1 4
2 12

请问应该怎么实现? SQL语句应该怎么写? 谢谢.

...全文

机器学习生产化：构建高韧性ML系统的核心实践机器学习模型上线并非项目终点，而是系统性挑战的起点。从概念上看，生产ML本质是将离线训练成果转化为可持续服务的工程系统；其核心原理在于以‘系统韧性’替代‘模型正确性’作为首要目标，通过解耦设计、失败假设与全链路可观测性应对真实流量冲击；技术价值体现在显著降低集成故障率、缩短MTTR、提升决策可审计性与业务响应速度；典型应用场景覆盖金融风控、支付反欺诈、信贷审批等强监管、高实时性领域；本文聚焦模型走出Jupyter后的七道生死关，深度融合‘特征漂移检测’与‘灰度发布机制’两大关键热词，提供可落地的韧性架构方法阅读详情

s_hluo

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

+ 关注 + 加入社区

切换为时间正序

borcas2010 2007-01-02

打赏
举报

hrb133yqq() ( ) 信誉：100 Blog 2006-12-31 16:09:55 得分: 0

create table table2(col1 int, col2 int)

insert into table2(col1,col2)
select 1, 4 union all
select 3, 6 union all
select 4, 6

select count(col1) as a ,sum(col2) as b from table2 where col1 between 1 and 2
union
select count(col1),sum(col2) from table2 where col1 between 3 and 4

这好象才是楼主想要的：）

marco08 2007-01-02

打赏
举报

create table T(A int, B int)
insert T select 1, 4
union all select 3, 6
union all select 4, 6

select result=1, r_sum=sum(B) from T
where A between 0 and 1
union all
select 2, sum(B) from T
where A between 3 and 4

--result
result r_sum
----------- -----------
1 4
2 12

(2 row(s) affected)

InFerNaL_LioN 2007-01-02

打赏
举报

create table #temp
(
A int,
B int
)

insert into #temp values(1,4)
insert into #temp values(3,6)
insert into #temp values(4,6)

select 1,
(
select sum(B) total from #temp
where A>=0
and A<=1
)
union all
select 2,
(
select sum(B) total from #temp
where A>=3
and A<=4
)

Well 2007-01-02

打赏
举报

union all进行联合

中国风 2006-12-31

打赏
举报

用表变量@ta测试:
--把表变量@ta改为表名就行了
declare @ta table (A int, B int)
insert @ta
select 1, 4
union all select 3, 6
union all select 4, 6
select result=case when a between 1 and 2 then 1 when a between 3 and 4 then 2 end,
r_sum=sum(b)
from @ta
group by case when a between 1 and 2 then 1 when a between 3 and 4 then 2 end

（所影响的行数为 3 行）

result r_sum
----------- -----------
1 4
2 12

（所影响的行数为 2 行）

中国风 2006-12-31

打赏
举报

用表变量@ta测试:
declare @ta table (A int, B int)
insert @ta
select 1, 4
union all select 3, 6
union all select 4, 6

select a=case when a between 1 and 2 then 1 when a between 3 and 4 then 2 end,
b=sum(b)
from @ta
group by case when a between 1 and 2 then 1 when a between 3 and 4 then 2 end

（所影响的行数为 3 行）

a b
----------- -----------
1 4
2 12

（所影响的行数为 2 行）

hrb133yqq 2006-12-31

打赏
举报

create table table2(col1 int, col2 int)

insert into table2(col1,col2)
select 1, 4 union all
select 3, 6 union all
select 4, 6

select count(col1) as a ,sum(col2) as b from table2 where col1 between 1 and 2
union
select count(col1),sum(col2) from table2 where col1 between 3 and 4

caixia615 2006-12-31

打赏
举报

select result,sum(b) as r_sum from(select result=(case when a between 0 and 1 then 1 end),b from @a where a between 0 and 1)a
group by result
union all
select result,sum(b) as r_sum from(select result=(case when a between 3 and 4 then 2 end),b from @a where a between 3 and 4)b
group by result

akuzou 2006-12-31

打赏
举报

楼上的语法估计有问题，你建个表试试看

caixia615 2006-12-31

打赏
举报

select result=(case when a between 0 and 1 then 1 end),r_sum=sum(b) from tablename where a between 0 and 1
~~~~~~~~这个不能写死, 因为它也是根据条件计算出来的.
union all
select result=(case when a between 3 and 4 then 2 end),r_sum=sum(b) from tablename where a between 3 and 4

s_hluo 2006-12-31

打赏
举报

select result=1,r_sum=sum(b) from tablename where a between 0 and 1
~~~~~~~~这个不能写死, 因为它也是根据条件计算出来的.
union all
select result=2,r_sum=sum(b) from tablename where a between 3 and 4

caixia615 2006-12-31

打赏
举报

select result=1,r_sum=sum(b) from tablename where a between 0 and 1
union all
select result=2,r_sum=sum(b) from tablename where a between 3 and 4

fellowcheng 2006-12-31

打赏
举报

一楼

caixia615 2006-12-31

打赏
举报

select result=1,r_sum=sum(b) from tablename where a between 1 and 2
union all
select result=2,r_sum=sum(b) from tablename where a between 3 and 4

请问怎么实现这个功能?

相关推荐