這行有錯嗎，提示語法錯誤
?SELECT GOODS_ID,GOODS_NAME,GOODS_PRICE FROM tdb_goods WHERE goods_price = （SELECT ROUND(AVG(goods_price),2) FROM tdb_goods);
3 回答
舉報
0/150
提交
取消
?SELECT GOODS_ID,GOODS_NAME,GOODS_PRICE FROM tdb_goods WHERE goods_price = （SELECT ROUND(AVG(goods_price),2) FROM tdb_goods);
2017-01-07
舉報
2017-01-07
SELECT goods_id,goods_name,goods_price FROM tdb_goods WHERE goods_price >= （SELECT ROUND(AVG(goods_price),2) FROM tdb_goods);
2017-03-21
錯誤的地方是子查詢的那個括號，是中文字符。不是英文的~?goods_price = （SELECT 這中間的那個
另外，GOODS_ID,GOODS_NAME,GOODS_PRICE 這樣也沒錯啦，但是規范下還是覺得小寫比較好寫又好看-，-
2017-01-07
?SELECT GOODS_ID,GOODS_NAME,GOODS_PRICE FROM tdb_goods WHERE goods_price >= （SELECT ROUND(AVG(goods_price),2) FROM tdb_goods);