子查詢?yōu)槭裁磮?bào)錯(cuò)？
mysql> SELECT goods_id,goods_name,goods_price FROM tdb_goods WHERE goods_price > ANY (SELECT goods_price FROM tdb_goods WHERE goods_price='超級(jí)本');
Empty set, 1 warning (0.00 sec)
這是什么原因？
qq_學(xué)無(wú)止盡_0
2017-07-11
2 回答
舉報(bào)
0/150
提交
取消
2017-07-11
應(yīng)該不是ANY是ALL吧
2017-07-11
mysql> SELECT goods_id,goods_name,goods_price FROM tdb_goods WHERE goods_price > ANY (SELECT goods_price FROM tdb_goods WHERE goods_cate='超級(jí)本');