摘要: eg1: with tmp as(select '1' id ,'aa' name from dual union allselect '2' id ,'bb' name from dualunion allselect '3' id ,'cc' name from dual)select a.*, 阅读全文