select field1 from table group by field1 having avg(field2) > 10
select field1 from table group by field1 having avg(field2) > 10
查询固定值可以了,谢谢各位,但是比如查询另一个表的呢? select tb1.field1 from tb1,tb2 group by tb1.field1 having avg(field2) > tb2.field1这样不行
select * from tb1 a,tb2 b where (select avg(field2) from tb1 where field1=a.field group by field1) > (select avg(field2) from tb2 where field1=a.field group by field1) and a.field=b.field
select tb1.field1 from tb1,tb2 group by tb1.field1 having avg(field2) > tb2.field1这样不行
(select avg(field2) from tb1 where field1=a.field group by field1)
>
(select avg(field2) from tb2 where field1=a.field group by field1)
and a.field=b.field