解释:未明确定义的列
原因:select bb.* from (select col1,col2,col3……..coln from tableXX )bb,其中col1,col2,col3..coln肯定有重复的列名称。
例如:
SELECT 1 AS cc ,2 AS cc FROM dual;这个语句是没错的。
而下面这个就有问题了:
SELECT * FROM ( SELECT 1 AS cc ,2 AS cc FROM dual );
解释:未明确定义的列
原因:select bb.* from (select col1,col2,col3……..coln from tableXX )bb,其中col1,col2,col3..coln肯定有重复的列名称。
例如:
SELECT 1 AS cc ,2 AS cc FROM dual;这个语句是没错的。
而下面这个就有问题了:
SELECT * FROM ( SELECT 1 AS cc ,2 AS cc FROM dual );