union all 支持排序吗

最新推荐文章于 2024-04-07 11:32:21 发布

now_do

最新推荐文章于 2024-04-07 11:32:21 发布

阅读量429

点赞数

文章标签： union all排序查询 select

本文链接：https://blog.csdn.net/now_do/article/details/39294005

版权

select * from ( select email.UUID as uid,email.UUID as uuid,re.receive_staff_id as peo,email.subject as subject,email.rank as rank,email.send_time as sendTime,email.is_stick as isStick from oa_email email,oa_email_rel re where re.email_id=email.UUID and email.send_staff_id = '"+form.getSendStaffId()+"' and email.status = '1104' union all select re.UUID as uid,re.UUID as uuid,email.send_staff_id as peo,email.subject as subject,re.rank as rank,email.send_time as sendTime ,re.is_stick as isStick from oa_email_rel re,oa_email email where re.receive_staff_id = '"+form.getSendStaffId()+"' and re.email_id =email.UUID and re.status = '1104') order by sendTime 这样写可以吗