葱葱那年丶 2018-06-12 09:18 采纳率: 100%
浏览 2791
已采纳

sql如何将一次查询的结果与另一次查询的结果合并并排序

查询1:
Select null as name,Checkinout.* from Checkinout where (Checkinout.userid=1000000000000 and (Checkinout.CheckTime >='2008-01-01 00:00:00') and (Checkinout.CheckTime <='2020-01-01 23:59:59')) Order By Checkinout.CheckTime DESC Limit '0','6'

查询2:
Select UserInfo.name,Checkinout.* from UserInfo left join Checkinout on Checkinout.userid=UserInfo.userid where ((Checkinout.CheckTime >='2008-01-01 00:00:00') and (Checkinout.CheckTime <='2020-01-01 23:59:59')) Order By Checkinout.CheckTime DESC Limit '0','6'

将这两次查询的结果合并后按照Checkinout.CheckTime排序

  • 写回答

9条回答 默认 最新

  • 雪花雨点 2018-06-12 09:21
    关注

    Select null as name,Checkinout.* from Checkinout where (Checkinout.userid=1000000000000 and (Checkinout.CheckTime >='2008-01-01 00:00:00') and (Checkinout.CheckTime <='2020-01-01 23:59:59')) Order By Checkinout.CheckTime DESC Limit '0','6'
    UNION
    Select UserInfo.name,Checkinout.* from UserInfo left join Checkinout on Checkinout.userid=UserInfo.userid where ((Checkinout.CheckTime >='2008-01-01 00:00:00') and (Checkinout.CheckTime <='2020-01-01 23:59:59')) Order By Checkinout.CheckTime DESC Limit '0','6'
    ORDER BY CheckTime;

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

报告相同问题?

悬赏问题

  • ¥15 彩灯控制电路,会的加我QQ1482956179
  • ¥200 相机拍直接转存到电脑上 立拍立穿无线局域网传
  • ¥15 (关键词-电路设计)
  • ¥15 如何解决MIPS计算是否溢出
  • ¥15 vue中我代理了iframe,iframe却走的是路由,没有显示该显示的网站,这个该如何处理
  • ¥15 操作系统相关算法中while();的含义
  • ¥15 CNVcaller安装后无法找到文件
  • ¥15 visual studio2022中文乱码无法解决
  • ¥15 关于华为5g模块mh5000-31接线问题
  • ¥15 keil L6007U报错