是不是某条记录你敲错了create table new(a int,b int,c int) insert into new values(1,1,1) insert into new values(2,2,2) insert into new values(3,3,3) insert into new values(4,4,4) insert into new values(5,5,5) insert into new values(6,6,6) insert into new values(7,7,7)select * from newSELECT COUNT(*) AS Expr1, AVG(b) AS Expr2 FROM new WHERE (c > 3)结果 4 5
insert into new values(1,1,1)
insert into new values(2,2,2)
insert into new values(3,3,3)
insert into new values(4,4,4)
insert into new values(5,5,5)
insert into new values(6,6,6)
insert into new values(7,7,7)select * from newSELECT COUNT(*) AS Expr1, AVG(b) AS Expr2
FROM new
WHERE (c > 3)结果 4 5
4 5.5