MySQL数据库子查询问题求解~

2025-03-30 21:12:01
推荐回答(1个)
回答1:

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