求大神看看
一、select goods_id,goods_name,goods_price from tdb_goods where goods_price >= (select round(avg(goods_price),2) from tdb_goods);
二、select goods_id,goods_name,goods_price from tdb_goods where goods_price >= (select round(avg(goods_price),2) );
求大神指點,第二句和第一句缺了from tdb_goods,但是沒報錯,還把所有記錄顯示出來了,請教下是什么意思,腦殼都大了沒看出來
2019-12-17
相當于是從tdb_goods表里的goods_price字段取平均值