ORA-00918:column ambiguously defined.
原因:使用相同的列被定义重复
SQL>select 1 as cc ,2 as cc from dual;
SQL>select * from (select 1 as ,2 as cc from dual);
解决办法:把相同的列名改成不同的列名
SQL>select 1 as cc ,2 as dd from dual;
SQL>select * from (select 1 as ,2 as dd from dual);
转载于:https://blog.51cto.com/dreamerhan/970256