SQL的COUNT语句
SQL的COUNT语句
日期:2009-08-24 07:37:56 人气:1
因为你的查询语句中加了count聚合函数,是要在where条件后加上分组语句的:
=SQLEXEC(lnHandle,"select id,rqi,qbc,fbc,COUNT(id) as fbbc,qlc+flc as ylc,qrs+frs as rs,qys+fys as ys from bcszl where (substring(rqi,6,2) = ?mo) and (substring(rqi,1,4) =?ye ) and (LTRIM(yxxl)=?yxx) gro