请帮我把这两句很长的SQL联起来吧

crazyceo 2010-11-01 11:37:57
第一句SQL---------------如下
select LinkID,count(*) as 出现次数 from 
(select A.LinkID,A.Speed,A.time,B.Class from T_yongdu A right join Linkthree B
on A.LinkID=B.LinkID) C
where C.Class=1 and C.Speed>20 and C.Speed<=35 and
C.LinkID=16239 and
C.time between '2010-07-26 07:00:00.000' and '2010-07-26 09:00:00.000'
Group by C.LinkID


第二句SQL----------------如下
select LinkID,count(*) as 总现次数 from 
(select A.LinkID,A.Speed,A.time,B.Class from T_yongdu A right join Linkthree B
on A.LinkID=B.LinkID) C
where C.Class=1 and
C.LinkID=16239 and
C.time between '2010-07-26 07:00:00.000' and '2010-07-26 09:00:00.000'
Group by C.LinkID


第一句查出来的东西是下面这个样子:
LindID 出现次数
16239 4
------------------------------------
第二句查出来的东西是下面这个样子:
LindID 总现次数
16239 9

现在我想把这两个SQL联起来,弄成下面这个表,请问如何联?唉,基础不牢,请帮看看:
LindID 出现次数 总现次数
16239 4 9
...全文
36 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
iamltd 2010-11-01
  • 打赏
  • 举报
回复

select LinkID,sum(case when c.speed between 20 and 35 then 1 esle 0 end) as 出现次数 ,count(1) as 总现次数 from
(select A.LinkID,A.Speed,A.time,B.Class from T_yongdu A right join Linkthree B
on A.LinkID=B.LinkID) C
where C.Class=1 and C.LinkID=16239 and
C.time between '2010-07-26 07:00:00.000' and '2010-07-26 09:00:00.000'
Group by C.LinkID
kevn 2010-11-01
  • 打赏
  • 举报
回复
select LinkID,sum(case when C.Speed>20 and C.Speed<=35 then 1 else 0 end) as 出现次数 ,count(*) as 总现次数 from 
(select A.LinkID,A.Speed,A.time,B.Class from T_yongdu A right join Linkthree B
on A.LinkID=B.LinkID) C
where C.Class=1 and
C.LinkID=16239 and
C.time between '2010-07-26 07:00:00.000' and '2010-07-26 09:00:00.000'
Group by C.LinkID


??
Xiao_Ai_Mei 2010-11-01
  • 打赏
  • 举报
回复
select LinkID,
sum(case when C.Speed>20 and C.Speed<=35 then 1 else 0 end) as 出现次数,
count(*) as 总现次数
from
(select A.LinkID,A.Speed,A.time,B.Class from T_yongdu A right join Linkthree B
on A.LinkID=B.LinkID) C
where C.Class=1 and
C.LinkID=16239 and
C.time between '2010-07-26 07:00:00.000' and '2010-07-26 09:00:00.000'
Group by C.LinkID

34,590

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server相关内容讨论专区
社区管理员
  • 基础类社区
  • 二月十六
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧