SELECT (cast((y.a+y.b+y.c+y.d+y.e+y.f)/((z.a+z.b+z.c+z.d+z.e+z.f)*1.000000) as decimal(18,10))-1) a
FROM TMY y cross join TMZ z group by a having COUNT(*)>0.5
...全文
6484打赏收藏
列名不明确的问题
大虾们帮看下是哪里的问题,下面的语句提示 列名a不明确,需要怎样改动,先谢谢: SELECT (cast((y.a+y.b+y.c+y.d+y.e+y.f)/((z.a+z.b+z.c+z.d+z.e+z.f)*1.000000) as decimal(18,10))-1) a FROM TMY y cross join TMZ z group by a having COUNT(*)>0.5