A. SUM, GROUP BY B. COUNT, GROUP BY C. GROUP BY, SUM D. GROUP BY, COUNT
A. Like "华" B. Like "%华" C. Like "%华%" D. Like "__华"
A. LIKE "A$Z" B. LIKE "A C. Z" D. LIKE "A%Z" E. LIKE "A_Z"
A. 4 B. 3 C. 2 D. 1
A. SELECT AVG(成绩) FROM choose WHERE 姓名="刘明"; B. SELECT AVG(成绩) FROM student, choose WHERE 姓名="刘明"; C. SELECT AVG(choose.成绩) FROM student, choose WHERE student.姓名="刘明"; D. SELECT AVG(choose.成绩) FROM student INNER JOIN choose ON student.学号=choose.学号 AND WHERE student.姓名="刘明";
A. SELECT * FROM 产品 WHERE 单价>600 AND (名称='主机板' AND 名称='硬盘'); B. SELECI * FROM 产品 WHERE 单价>600 AND (名称='主机板' OR 名称='硬盘'); C. SELECT * FROM 产品 ON 单价>600 AND (名称='主机板' AND 名称='硬盘'); D. SELECT * FROM 产品 ON 单价>600 AND (名称='主机板' OR 名称='硬盘');
A. SELECT DISTINCT 部门号 FROM 职工 WHERE 基本工资>=ANY (SELECT 基本工资 FROM 职工 WHERE 部门号='11'); B. SELECT DISTINCT 部门号 FROM 职工 WHERE 基本工资>=ALL (SELECT 基本工资 FROM 职工 WHERE 部门号='11'); C. SELECT DISTINCT 部门号 FROM 职工 WHERE 基本工资>=ANY (SELECT MAX(基本工资) FROM 职工 WHERE 部门号='11'); D. SELECT DISTINCT 部门号 FROM 职工 WHERE 基本工资>=ALL (SELECT MIN(基本工资) FROM 职工 WHERE 部门号='11');
A. SELECT 部门名称, SUM(基本工资) FROM 部门 INNER JOIN 职工 ON 部门.部门号=职工.部门号 ORDER BY 部门号; B. SELECT 部门名称, SUM(基本工资) FROM 部门 INNER JOIN 职工 ON 部门.部门号=职工.部门号 GROUP BY 部门号; C. SELECT 部门名称, SUM(基本工资) FROM 部门 INNER JOIN 职工 ON 部门.部门号=职工.部门号 ORDER BY 职工.部门号; D. SELECT 部门名称, SUM(基本工资) FROM 部门 INNER JOIN 职工 ON 部门.部门号=职工.部门号 GROUP BY 职工.部门号;
A. SELECT 学号 FROM sc WHERE 课程号='C1' AND 课程号='C5'; B. SELECT 学号 FROM sc WHERE 课程号='C1' AND 课程号= (SELECT 课程号 FROM sc WHERE 课程号='C5'); C. SELECT 学号 FROM sc WHERE 课程号='C1' AND 学号= (SELECT 学号 FROM sc WHERE 课程号='C5'); D. SELECT 学号 FROM sc WHERE 课程号='C1' AND 学号 IN (SELECT 学号 FROM sc WHERE 课程号='C5');
A. SELECT * FROM 职工 WHERE 出生日期=1980-8-20; B. SELECT * FROM 职工 WHERE 出生日期='1980-8-20'; C. SELECT * FROM 职工 WHERE 出生日期={1980-8-20}; D. SELECT * FROM 职工 WHERE 出生白期=[1980-8-20];
微信支付 
支付宝支付