942      阿里云  技术社区[云栖]

ORACLE union order by

select * from (
select a.id,a.oacode,a.custid,a.custname,a.xsz,a.salename,a.communicationtheme,a.communicationproperty,a.communicationtime,a.productmanager,a.creator,a.createdate from technology_flow a 
where a.oastate='正常结束'
union 
select b.id,b.oacode,b.custid,b.custname,b.xsz,b.salename,b.communicationtheme,b.communicationproperty,b.communicationtime,b.productmanager,b.creator,b.createdate  from technology_support b
) t order by t.oacode desc

最后更新：2017-04-03 07:57:07

  上一篇： JAVA 【引用类型】和【对象类型】在【继承】中的异同

  下一篇： Java程序员也应该知道的系统知识系列之磁盘