一次查询为何返回这么多重复记录!!如果要计算一列 的和该怎么办呢??

checkyvc6 2002-12-17 10:45:17
SELECT e2.SectionId, e2.SectionDistance, d2.TrainSectionSequence
FROM E_Station AS a1,E_Station AS a2, R_TrainStation AS b, E_Train AS c, R_TrainSection AS d1, R_TrainSection AS d2, E_Section AS e1, E_Section AS e2
WHERE a2.StationName="广州北" And a1.StationName="广州东" And c.TrainName="K254" And c.TrainId=b.TrainId And d1.TrainId=c.TrainId And e1.SectionEnd=a2.StationId And d1.SectionId=e1.SectionId And d2.TrainId=c.TrainId And (d2.TrainSectionSequence Between 1 And (d1.TrainSectionSequence-1)) And e2.SectionId=d2.SectionId
ORDER BY d2.TrainSectionSequence;
...全文
53 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
artmouse 2002-12-18
  • 打赏
  • 举报
回复
你想怎么样,只返回一条记录
加个top 1 ,就返回第一条了
SELECT top 1 e2.SectionId, e2.SectionDistance, d2.TrainSectionSequence
FROM E_Station AS a1,E_Station AS a2, R_TrainStation AS b, E_Train AS c, R_TrainSection AS d1, R_TrainSection AS d2, E_Section AS e1, E_Section AS e2
WHERE a2.StationName="广州北" And a1.StationName="广州东" And c.TrainName="K254" And c.TrainId=b.TrainId And d1.TrainId=c.TrainId And e1.SectionEnd=a2.StationId And d1.SectionId=e1.SectionId And d2.TrainId=c.TrainId And (d2.TrainSectionSequence Between 1 And (d1.TrainSectionSequence-1)) And e2.SectionId=d2.SectionId
ORDER BY d2.TrainSectionSequence;
pengdali 2002-12-17
  • 打赏
  • 举报
回复
select sum(你要求和的列) 和 from (SELECT e2.SectionId, e2.SectionDistance, d2.TrainSectionSequence
FROM E_Station AS a1,E_Station AS a2, R_TrainStation AS b, E_Train AS c, R_TrainSection AS d1, R_TrainSection AS d2, E_Section AS e1, E_Section AS e2
WHERE a2.StationName='广州北' And a1.StationName='广州东' And c.TrainName="K254" And c.TrainId=b.TrainId And d1.TrainId=c.TrainId And e1.SectionEnd=a2.StationId And d1.SectionId=e1.SectionId And d2.TrainId=c.TrainId And (d2.TrainSectionSequence Between 1 And (d1.TrainSectionSequence-1)) And e2.SectionId=d2.SectionId
ORDER BY d2.TrainSectionSequence) A

34,575

社区成员

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

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