你可能感兴趣的试题
SELECT订单号,签订日期,金额FROM订单WHERE EXISTS；
(SELECT*FROM职员WHERE姓名="李二") SELECT订单号,签订日期,金额FROM订单WHERE EXISTS；
(SELECT*FROM职员WHERE职员号=订单.职员号AND姓名="李二") SELECT订单号,签订日期,金额FROM订单WHERE IN；
(SELECT职员号FROM职员WHERE姓名="李二") SELECT订单号,签订日期,金额FROM订单WHERE IN；
(SELECT职员号FROM职员WHERE职员号=订单.职员号AND姓名="李二")
UPDATE 订单 SET 金额=169 WHERE 订单号=“0060” UPDATE 订单 SET 金额 WITH l69 WHERE 订单号=“0060” UPDATE FROM 订单 SET 金额=169 WHERE 订单号=“0060” UPDATE FROM 订单 SET 金额 WITH l69 WHERE 订单号=“0060”
UPDATE订单 SET 金额=169 WHERE 订单号="0060" UPDATE 订单 SET 金额WITH l69 WHERE 订单号="0060" UPDATE FROM订单 SET 金额=169 WHERE 订单号="0060" UPDATE FROM订单 SET 金额WITH l69 WHERE 订单号="0060"
SELECT 订单号，签订日期，金额FROM订单
WHERE EXISTS (SELECT*FROM 职员 WHERE 姓名=“李二”) SELECT 订单号，签订日期，金额 FROM 订单 WHERE
EXISTS(SELECT*FROM 职员 WHERE 职员号=订单.职员号 AND 姓名=“李二”) SELECT 订单号，签订日期，金额FROM 订单
WHERE IN (SELECT 职员号 FROM 职员 WHERE 姓名=“李二”) SELECT 订单号，签订日期，金额FROM 订单 WHERE
IN (SELECT 职员号 FROM 职员 WHERE职员号=订单.职员号 AND 姓名=“李二”)
SELECT 订单号，签订日期，金额 FROM 订单 WHERE EXISTS；(SELECT*FROM 职员 WHERE 姓名="李二") SELECT订单号，签订日期，金额 FROM 订单 WHERE EXISTS；(SELECT*FROM 职员 WHERE职员号=订单.职员号 AND 姓名="李二") SELECT 订单号，签订日期，金额 FROM 订单 WHERE IN；(SELECT 职员号 FROM 职员 WHERE 姓名="李二") SELECT 订单号，签订日期，金额 FROM 订单 WHERE IN；(SELECT 职员号 FROM 职员 WHERE 职员号=订单.职员号 AND 姓名="李二")
SELECT职员号FROM订单 GROUP BY职员号HAVING COUNT(*)＞3 AND AVG金额＞200 SELECT职员号FROM订单 GROUP BY职员号HAVING COUNT(*)＞3 AND AVG(金额)＞200 SELECT职员号FROM订单 GROUP BY职员号HAVING COUNT(*)＞3WHERE AVG(金额)＞200 SELECT职员号FROM订单 GROUP BY职员号WHERE COUNT(*)＞3AND AVG金额＞200
SELECT 订单号,签订日期,金额 FROM 订单 WHERE EXISTS(SELECT * FROM 职员 WHERE 姓名="李二") SELECT 订单号,签订日期,金额 FROM 订单 WHERE EXISTS(SELECT * FROM 职员 WHERE 职员号=订单.职员号 AND 姓名="李二") SELECT 订单号,签订日期,金额 FROM 订单 WHERE IN(SELECT 职员号 FROM 职员 WHERE 姓名="李二") SELECT 订单号,签订日期,金额 FROM 订单 WHERE IN(SELECT 职员号 FROM 职员 WHERE 职员号=订单.职员号 AND 姓名="李二")
SELECT 职员号 FROM 订单 GROUP BY 职员号 HAVING COUNT(*)>3 AND AVG_金额>200 SELECT 职员号 FROM 订单 GROUP BY 职员号 HAVING COUNT(*)>3 AND AVG(金额)>200 SELECT 职员号 FROM 订单 GROUP BY 职员号 HAVING COUNT(*)>3 WHERE AVG(金额)>200 SELECT 职员号 FROM 订单 GROUP BY 职员号 WHERE COUNT(*)>3 AND AVG_金额>200
UPDATE订单SET金额=169 WHERE订单号="0060" UPDATE订单SET金额WITH 169 WHERE订单号="0060" UPDATE FROM订单SET金额=169 WHERE订单号="0060" UPDATE FROM订单SET金额WITH 169 WHERE订单号="0060"
SELECT 职员号 FROM 订单 GROUP BY 职员号 HAVING COUNT(*)>3 AND AVG_金额>200 SELECT 职员号 FROM 订单 GROUP BY 职员号 HAVING COUNT(*)>3 AND AVG(金额)>200 SELECT 职员号 FROM 订单 GROUP BY 职员号 HAVING COUNT(*)>3 WHERE AVG(金额)>200 SELECT 职员号 FROM 订单 GROUP BY 职员号 WHERE COUNT(*)>3 AND AVG_金额>200
UPDATE 订单 SET 金额=169 WHERE 订单号="0060" UPDATE 订单 SET 金额 WITH 169 WHERE 订单号="0060" UPDATE FROM 订单 SET 金额=169 WHERE 订单号="0060" UPDATE FROM 订单 SET 金额 WITH 169 WHERE 订单号="0060"
SELECT职员号FROM订单
GROUP BY职员号HAVING COUNT(*)＞3 AND AVG金额＞200 SELECT职员号FROM订单
GROUP BY 职员号HAVING COUNT(*)＞3 AND AVG金额＞200 SELECT职员号FROM订单
GROUP BY职员号HAVINGCOUNT(*)＞3 WHEREAVG金额＞200 SELECT职员号FROM订单
GROUP BY职员号WHERE COUNT(*)＞3 AND AVG金额＞200
SELECT订单号，签订日期，金额FROM订单;
WHERE EXISTS(SELECT*FROM职员WHERE姓名="李二") SELECT订单号，签订日期，金额FROM订单WHERE;
EXISTS(SELECT*FROM职员WHERE职员号=订单.职员号AND姓名="李二") SELECT订单号，签订日期，金额FROM订单;
WHEREIN(SELECT职员号FROM职员WHERE姓名="李二") SELECT订单号，签订日期，金额FROM订单WHERE;
IN(SELECT职员号FROM职员WHERE职员号=订单.职员号AND姓名="李二")
SELECT职员号FROM订单GROUP BY职员号HAVING COUNT(*)＞3 AND AVG_金额＞200 SELECT职员号FROM订单GROUP BY职员号HAVING COUNT(*)＞3 AND AVG(金额)＞200 SELECT职员号FROM订单GROUP BY职员号HAVING COUNT(*)＞3 WHERE AVG(金额)＞200 SELECT职员号FROM订单GROUP BY职员号WHERE COUNT(*)＞3 AND AVG_金额＞200
SELECT订单号，签订日期，金额FROM订单 WHERE EXISTS(SELECT * FROM职员WHERE 姓名="李二") SELECT订单号，签订日期，金额FROM订单WHERE EXISTS(SELECT * FROM职员WHERE职员号=订单.职员号AND姓名="李二") SELECT订单号，签订日期，金额FROM订单 WHERE IN(SELECT职员号FROM职员WHERE姓名="李二") SELECT订单号，签订日期，金额FROM订单WHERE IN(SELECT职员号FROM职员WHERE职员号=订单.职员号AND姓名="李二")
SELECT 订单号，签订日期，金额FROM订单 WHERE EXISTS (SELECT*FROM 职员 WHERE 姓名=“李二”) SELECT 订单号，签订日期，金额 FROM 订单 WHERE EXISTS(SELECT*FROM 职员 WHERE 职员号=订单.职员号 AND 姓名=“李二”) SELECT 订单号，签订日期，金额FROM 订单 WHERE IN (SELECT 职员号 FROM 职员 WHERE 姓名=“李二”) SELECT 订单号，签订日期，金额FROM 订单 WHERE IN (SELECT 职员号 FROM 职员 WHERE职员号=订单.职员号 AND 姓名=“李二”)
UPDATE订单SET金额=169 WHERE订单号="0060" UPDATE订单SET金额WITH 169 WHERE订单号="0060" UPDATE FROM订单SET金额=169 WHERE订单号="0060" UPDATE FROM订单SET金额WITH 169 WHERE订单号="0060"
SELECT 订单号，签订日期，金额 FROM 订单 WHERE EXISTS(SELECT * FROM 职员 WHERE 姓名="王五") SELECT 订单号，签订日期，金额 FROM 订单 WHERE EXISTS(SELECT * FROM 职员 WHERE 职员号=订单.职员号 AND 姓名="王五") SELECT订单号，签订日期，金额 FROM 订单 WHERE IN(SELECT 职员号 FROM 职员 WHERE 姓名="李二") SELECT 订单号，签订日期，金额 FROM 订单 WHERE IN(SELECT 职员号 FROM 职员 WHERE 职员号=订单.职员号 AND 姓名="王五")
SELECT 金额＞10000 FROM 订单 FOR 订单号 SELECT 订单号 FROM 订单 FOR 金额＞10000 SELECT 金额＞10000 FROM 订单 WHERE 订单号 SELECT 订单号 FROM 订单 WHERE 金额＞10000
湘公网安备 43130202000226号