有关Grouping,having的用法(oracle816)
zheng 2000-12-16 11:14:00 select M.mlbh as mlbh,
M.cldl as cldl,
M.cllb as cllb,
Max(M.JGDE) as JGDE,
Max(M.CGDE) as CGDE,
Grouping(cldl) as T,
Grouping(MLBH) as D,
Grouping(cllb) as F
from Money M group by rollup(cldl,MLBH,cllb)
having (T=1 and D=1 and F=1)
出错:invalid column:(T,D,F);
当去掉最后一行,没有错误。
oracle书上的例子也是这样的。不明白我这儿为什么就不认识 T,D,F这三个column