对 union 结果进行排序
# 第一种排序 select msgId ,body ,[from] ,[to] ,timetag ,attach ,convType ,type as msgType from MessageRecord where [from] = 'aaa' and [to] = 'bbb' and timetag < '1625220012990' UNION select msgId ,body ,[from] ,[to] ,timetag ,attach ,convType ,type as msgType from MessageRecord where [to] = 'bbb' and [from] = 'aaa' and timetag < '1625220012990' order by timetag DESC; # 第二种排序 select row_number() over (order by timetag DESC) row_num, * FROM ( (select msgId ,body ,[from] ,[to] ,timetag ,attach ,convType ,type as msgType from MessageRecord where [from] = 'aaa' and [to] = 'bbb' and timetag < '1625220012990' ) UNION (select msgId ,body ,[from] ,[to] ,timetag ,attach ,convType ,type as msgType from MessageRecord where [to] = 'bbb' and [from] = 'aaa' and timetag < '1625220012990' ) )temp;
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步