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程序員也應該知道的係統知識係列之磁盤