表的结构
求time字段值的总和(sum)除以id的条数(count) WHERE only='114' AND er="ok" AND time<>0 的结果我现在用的PHP这方法$sql="SELECT count(id) FROM `clicked` WHERE `er`='ok' AND `only`='114' AND `time`<>'0'";
$count1=mysql_query($sql);
$row1=mysql_fetch_array($count1);
$sql="SELECT sum(time) FROM `clicked` WHERE `er`='ok' AND `only`='114'";
$sum1=mysql_query($sql);
$row2=mysql_fetch_array($sum1);
$pingjun=$row2[0]/$row1[0]怎么整合为一条 最后求出值
SELECT sum(if(`time`<>'0',1,0))/sum(time) FROM `clicked` WHERE `er`='ok' AND `only`='114');
直接用你的SQL语句SELECT sum(time)/(SELECT count(id) FROM `clicked` WHERE `er`='ok' AND `only`='114' AND `time`<>'0') FROM `clicked` WHERE `er`='ok' AND `only`='114'or
SELECT sum(time)/count(id) FROM `clicked` WHERE `er`='ok' AND `only`='114'
where e='ok' and only='114';
SELECT sum(time)/count(id) FROM `clicked` WHERE `er`='ok' AND `only`='114'); 就可以了。