select KPITARGET from PA_TG_TABLE where TABLE_YEAR='2010' and QUARTER = '年度' and TABLE_TYPE = '大区' group by KPITARGET
上面没有问题
可我想对查到的数据按表PA_TG_TABLE里面的ROW_NO字段排序
select KPITARGET from PA_TG_TABLE where TABLE_YEAR='2010' and QUARTER = '年度' and TABLE_TYPE = '大区' group by KPITARGET order by ROW_NO
错误 列名 'PA_TG_TABLE.ROW_NO' 在 ORDER BY 子句中无效,因为该列既不包含在聚合函数中,也不包含在 GROUP BY 子句中。
select KPITARGET,ROW_NO from PA_TG_TABLE where TABLE_YEAR='2010' and QUARTER = '年度' and TABLE_TYPE = '大区' group by KPITARGET order by ROW_NO
错误 列 'PA_TG_TABLE.ROW_NO' 在选择列表中无效,因为该列既不包含在聚合函数中,也不包含在 GROUP BY 子句中。
上面没有问题
可我想对查到的数据按表PA_TG_TABLE里面的ROW_NO字段排序
select KPITARGET from PA_TG_TABLE where TABLE_YEAR='2010' and QUARTER = '年度' and TABLE_TYPE = '大区' group by KPITARGET order by ROW_NO
错误 列名 'PA_TG_TABLE.ROW_NO' 在 ORDER BY 子句中无效,因为该列既不包含在聚合函数中,也不包含在 GROUP BY 子句中。
select KPITARGET,ROW_NO from PA_TG_TABLE where TABLE_YEAR='2010' and QUARTER = '年度' and TABLE_TYPE = '大区' group by KPITARGET order by ROW_NO
错误 列 'PA_TG_TABLE.ROW_NO' 在选择列表中无效,因为该列既不包含在聚合函数中,也不包含在 GROUP BY 子句中。
你只select KPITARGET,也就是分组依据的字段,最后加order by子句又有什么用呢!
KPITARGET ROW_NO
df 1
324e 1
we 3
er 4
select KPITARGET,ROW_NO
from PA_TG_TABLE
where TABLE_YEAR='2010' and QUARTER = '年度' and TABLE_TYPE = '大区'
group by KPITARGET,ROW_NO
order by ROW_NO
from PA_TG_TABLE
where TABLE_YEAR='2010' and QUARTER = '年度' and TABLE_TYPE = '大区'
group by KPITARGET,ROW_NO
order by ROW_NO