MYSQL 多级子查询 简单问题求助

2024-11-30 01:33:05
推荐回答(1个)
回答1:

SELECT goods_id,goods_name,goods_price FROM tdb_goods WHERE goods_price=(SELECT ROUND (AVG(goods_price),2) FROM tdb_goods);