SELECT goods_id,goods_name,goods_price FROM tdb_goods
WHERE goods_price = ALL (SELECT goods_price FROM tdb_goods
WHERE goods_cate='超级本');
SELECT goods_id,goods_name,goods_price FROM tdb_goods
WHERE goods_price <> ALL (SELECT goods_price FROM tdb_goods
WHERE goods_cate='超级本');
你们说看不清的代码
WHERE goods_price = ALL (SELECT goods_price FROM tdb_goods
WHERE goods_cate='超级本');
SELECT goods_id,goods_name,goods_price FROM tdb_goods
WHERE goods_price <> ALL (SELECT goods_price FROM tdb_goods
WHERE goods_cate='超级本');
你们说看不清的代码
2017-04-08
很棒,谢谢老师,讲得很细致,有了基础的概念认知,相信对今后的学习会有很大帮助,感恩!!!
2017-04-06
看清 看不清 都无所谓 老师打个 您给我 看到完整的代码好么?? 把代码 弄到 一条上 很困难么??我服了 每次 都要猜 隐藏的那部分代码是什么东西!! 真是服了!!
2017-04-05