SQL的COUNT语句

日期:2009-08-24 07:37:56 人气:1

SQL的COUNT语句

因为你的查询语句中加了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
    A+
热门评论