m0_37908418 2018-12-18 11:23 采纳率: 70.2%
浏览 659
已采纳

怎样将查询出的记录合并到一行 不重复

怎样通过查询将下面的重复cardno 变成一行即

workshop cardno qty Inticket exitticket
T01 116680300169 2 4 20
T01 116680300170 2 4 20


select
total.Workshop,
total.Card# as cardno,COUNT(*)as qty,
case when total.Ticket#=4 then total.Ticket# end as Inticket,
case when total.Ticket#=20 then total.Ticket# end as exitticket
from(
select
only.Ticket#,
only.[Receive Time],
only.Workshop,
only.Card#
from test.dbo.TicketDetailData125 only
group by
only.Workshop,
only.Card#,
only.Ticket#,
only.[Receive Time]

)total
where
total.Workshop=total.Workshop
group by
total.Workshop,
total.Card#,
total.Ticket#,
total.[Receive Time]
order by
total.Workshop
现在查出的结果
图片说明

  • 写回答

3条回答 默认 最新

  • liangtianlin2006 2018-12-18 05:08
    关注

    select
    total.Workshop,
    total.Card# as cardno,COUNT(*)as qty,
    MAX(case when total.Ticket#=4 then total.Ticket# END) as Inticket,
    MAX(case when total.Ticket#=20 then total.Ticket# END) as exitticket
    from(
    select
    only.Ticket#,
    only.[Receive Time],
    only.Workshop,
    only.Card#
    from test.dbo.TicketDetailData125 only
    group by
    only.Workshop,
    only.Card#

    )total
    where
    total.Workshop=total.Workshop
    group by
    total.Workshop,
    total.Card#
    order by
    total.Workshop

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 关于PLUS模型中kapaa值的问题
  • ¥15 关于博途V17进行仿真时无法建立连接问题
  • ¥15 请问下这个红框里面是什么文档或者记事本编辑器
  • ¥15 机器学习教材中的例题询问
  • ¥15 求.net core 几款免费的pdf编辑器
  • ¥15 为什么安装HCL 和virtualbox之后没有找到VirtualBoxHost-OnlyNetWork?
  • ¥15 C# P/Invoke的效率问题
  • ¥20 thinkphp适配人大金仓问题
  • ¥20 Oracle替换.dbf文件后无法连接,如何解决?(相关搜索:数据库|死循环)
  • ¥15 数据库数据成问号了,前台查询正常,数据库查询是?号