全国咨询热线：136-9172-9932
分治思想. 复杂的查询分解为若干个简单的查询.子查询的引入 #找出商店售价比 诺基亚E66 要贵的产品的信息 s1. get 诺基亚E66 price SELECT shop_price FROM ecs_goods WHERE goods_name = '诺基亚E66'; #2298.00 s2. ALL price > 2298.0 SELECT * FROM ecs_goods WHERE shop_price > 2298.0; SELECT * FROM ecs_goods WHERE shop_price > (SELECT shop_price FROM ecs_goods WHERE goods_name = '诺基亚E66');
