戴武宁

select x1,x2,x3... from (with mx as (select x1,x2,x3,(select x4 from m where ... and rownum from x,y,zwhere ... )select x1,x2,x3... from mxunion allselect x1,x2,'' x3,...sum(x7

with重用子查询：with a as (select * from b where xxx)select * from a where xxx;层次查询：select * from a where 1=1 start with id = root connect by prior parent = id合并查询：union 去掉重复记录；union all 包含重复记

SELECT LogID，UserID，LogTime，Url，Description，（case OperateType when OperateType = 0 then ‘新增’ when OperateType＝1 then ‘修改’ else ‘删除’ end case） FROM LOG1. caseSELECT LogID，UserID，LogTime，Url，Descrip