SELECT count(U.IDUser),sum(intAmount),sum(IF(AAction.fIDProd BETWEEN 200 AND 300,intAmount,0)) as domaincharge FROM AAction LEFT JOIN USERS U ON (IF (fidVCP >0, fidVCP, AAction.fidUserP)=U.IDUser) WHERE U.VCP=9 group by U.IDUser having domaincharge>1000 这样写??? 但取出来的就不是一条记录了啊
你要取出这个SQL语句一共有几条记录???用于分页吗??
是的要用于分页。。我要统计出有多少条记录。。再去limit 明白了么?
1.select count(*) as num from (SELECT count(U.IDUser),sum(intAmount),sum(IF(AAction.fIDProd BETWEEN 200 AND 300,intAmount,0)) as domaincharge FROM AAction LEFT JOIN USERS U ON (IF (fidVCP >0, fidVCP, AAction.fidUserP)=U.IDUser) WHERE U.VCP=9 group by U.IDUser having domaincharge>1000) as a 有group by 和distinct的可以如此处理2.第二个方法也差不多 就是先用SQL取出记录,然后移到最后一行,取行数
这样写???
但取出来的就不是一条记录了啊
有group by 和distinct的可以如此处理2.第二个方法也差不多
就是先用SQL取出记录,然后移到最后一行,取行数