如何实现如下功能的sql

2007-12-11 03:14:45 156 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

用pandas实现sql功能 SQL Pandas select * from airports airports select * from airports limit 3 airports.head(3) select id from airports where ident = ‘KLAX’ airports[airports.ident == ‘KLAX’].id ... 阅读详情

数据库记录
id Vote
44 -2
51 -3
51 1
52 -1

输出
id -vote +vote
44 -2
51 -3 1
52 -1

每个ID这只可能有 1-2 行记录

...全文

Ubuntu 24.04 搭建 Squid 代理服务器终极指南：从入门到 HTTPS 缓存AI模型本文详细指导在Ubuntu 24.04系统部署Squid代理服务器，实现AI大模型文件的高效缓存。重点内容包括：1) 安装squid及必备的squid-openssl扩展包；2) 配置HTTPS拦截(SSL-Bumping)功能，创建CA证书和SSL数据库；3) 优化缓存策略，设置4TB存储空间并强制缓存常见大文件格式；4) 结合华为防火墙实现透明代理。文章特别强调实际部署中的关键注意事项和常见错误解决方案，如证书路径配置、权限设置等问题，帮助用户快速搭建企业级缓存代理服务。阅读详情

singer_101

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

+ 关注 + 加入社区

切换为时间正序

East271536394 2008-04-22

打赏
举报

select id,max(case when vote<0 then vote else null end) as '-vote',max(case when vote>0 then vote else null end) as '+vote' from # group by id

id -vote +vote
----------- ----------- -----------
44 -2 NULL
51 -3 1
52 -1 NULL

lingyunfeipu 2008-04-22

打赏
举报

收藏，jf

andysun88 2007-12-11

打赏
举报

test

select id
,(select vote from test where vote < 0 and id=te.id) as '-vote'
,(select vote from test where vote > 0 and id=te.id) as '+vote'
from test te group by id

測試結果:
id -vote +vote
----------- ----------- -----------
44 -2 NULL
51 -3 1
52 -1 NULL

fwacky 2007-12-11

打赏
举报



/*

id          vote1       vote2       

----------- ----------- ----------- 

44          -2          NULL

51          -3          1

52          -1          NULL



（所影响的行数为 3 行）

*/

fwacky 2007-12-11

打赏
举报



create table singer_101 

(id int,



vote int)

insert into singer_101 values(44,-2)



insert into singer_101 values(51,-3)



insert into singer_101 values(51,1)



insert into singer_101 values(52,-1)



select id, sum(case  when vote > 0 then vote else null end ) as '-vote' ,

sum(case  when vote < 0 then vote else null  end ) as '+vote'  from singer_101

group by id

dawugui 2007-12-11

打赏
举报

create table  tb(id int,vote int)



insert into  tb values(44,-2)



insert into  tb values(51,-3)



insert into  tb values(51,1)



insert into  tb values(52,-1)



select isnull(t1.id , t2.id) id , t1.vote vote1 , t2.vote vote2 from

(select id , vote from tb where vote < 0) t1

full join

(select id , vote from tb where vote > 0) t2

on t1.id = t2.id

order by t1.id



drop table tb



/*

id          vote1       vote2       

----------- ----------- ----------- 

44          -2          NULL

51          -3          1

52          -1          NULL



（所影响的行数为 3 行）

*/

dawugui 2007-12-11

打赏
举报

select isnull(t1.id , t2.id) id , t1.vote vote1 , t2.vote vote2 from

(select id , vote from tb where vote < 0) t1

full join

(select id , vote from tb where vote > 0) t2

on t1.id = t2.id

kk19840210 2007-12-11

打赏
举报





create table #(id int,vote int)



insert into # values(44,-2)



insert into # values(51,-3)



insert into # values(51,1)



insert into # values(52,-1)







select id,max(case  when vote<0 then vote else null end) as '-vote',max(case  when vote>0 then vote else null end) as '+vote' from # group by id



id          -vote       +vote

----------- ----------- -----------

44          -2          NULL

51          -3          1

52          -1          NULL

警告: 聚合或其他 SET 操作消除了空值。



(3 行受影响)

如何实现如下功能的sql

相关推荐