你可能感兴趣的试题
SELECT 部门号,COUNT(*),SUM(工资)FROM 职工表;
HAVING COUNT(*)>=3 SELECT 部门号,COUNT(*),SUM(工资)FROM 职工表;
GROUP BY 部门号 HAVING COUNT(*)>=3 SELECT 部门号,COUNT(*),SUM(工资)FROM 职工表;
GROUP BY 部门号 SET COUNT(*)>=3 SELECT 部门号,COUNT(*),SUM(工资)FROM 职工表;
GROUP BY 部门号 WHERE COUNT(*)>=3
SELECT 仓库号,COUNT(*),AVG(工资)FROM职工表; HAVING COUNT(*)>;2 SELECT 仓库号,COUNT(*),AVG(工资)FROM职工表; GROUP BY 仓库号 HAVING COUNT(*)>=2 SELECT 仓库号,COUNT(*),AVG(工资)FROM职工表; GROUP BY 仓库号 SET COUNT(*)>=2 SELECT 仓库号,COUNT(*),AVG(工资)FROM职工表; GROUP BY 仓库号 WHERE COUNT(*)>=2
either ; or neither ; nor not only ; but also not ; but
SELECT 部门号,COUNT(*),SUM(工资)FROM 职工表;
HAVING COUNT(*)>=3 SELECT 部门号,COUNT(*),SUM(工资)FROM职工表;
GROUP BY 部门号 HAVING COUNT(*)>=3 SELECT 部门号,COUNT(*),SUM(工资)FROM 职工表;
GROUP BY 部门号 SET COUNT(*)>=3 SELECT 部门号,COUNT(*),SUM(工资)FROM职工表;
GROUP BY 部门号 WHERE COUNT(*)>=3
different from; in that differs from; in which differs from; in that is different from; in which
SELECT仓库号,COUNT( * )AS人数,AVG(工资)AS平均工资FROM职工; GROUP BY仓库号WHERE COUNT( * )>=3 SELECT仓库号,COUNT( * )AS人数,AVG(工资)AS平均工资FROM职工; GROUP BY仓库号HAVING COUNT( * )>=3 SELECT仓库号,COUNT( * )AS人数,COUNT(工资)AS平均工资FROM职工; GROUP BY仓库号WHERE COUNT( * )>=3 SELECT仓库号,COUNT( * )AS人数,COUNT(工资)AS平均工资FROM职工; GROUP BY仓库号HAVING COUNT( * )>=3
SELECT部门号,COUNT( * ),SUM(工资)FROM职工表; HAVING COUNT( * )>=3 SELECT部门号,COUNT( * ),SUM(工资)FROM职工表; GROUP BY部门号HAVING COUNT( * )>=3 SELECT部门号,COUNT( * ),SUM(工资)FROM职工表; GROUP BY部门号SETCOUNT( * )>=3 SELECT部门号,COUNT( * ),SUM(工资)FROM职工表; GROUP BY部门号WHERE COUNT( * )>=3
in; from from; in in; between from; between
SELECT COUNT(DISTINCT学生号)FROM选课 SELECT COUNT(学生号)FROM选课 SELECT COUNT(*)FROM选课 SELECT COUNT(DISTINCT*)FROM选课
/, that that, / how, that that, that
that ; what the ; / what ;that that ; that
different from; in that differs from; in which differs from; in that is different from; in which
from…in with…at from…on in…from
SELECT 部门号,COUNT(*),SUM(工资)FROM 职工表; HAVING COUNT(*)>=3 SELECT 部门号,COUNT(*),SUM(工资)FROM职工表; GROUP BY 部门号 HAVING COUNT(*)>=3 SELECT 部门号,COUNT(*),SUM(工资)FROM 职工表; GROUP BY 部门号 SET COUNT(*)>=3 SELECT 部门号,COUNT(*),SUM(工资)FROM职工表; GROUP BY 部门号 WHERE COUNT(*)>=3
SELECT COUNT(DISTINCT S#)FROM SC SELECT COUNT(S#)FROM SC SELECT COUNT(*)FROM SC SELECT COUNT(DISTINCT)FROM SC
SELECT 部门号,COUNT(*),SUM(工资)FROM 职工表; HAVING COUNT(*)>=3 SELECT 部门号,COUNT(*),SUM(工资)FROM 职工表; GROUP BY 部门号 HAVING COUNT(*)>=3 SELECT 部门号,COUNT(*),SUM(工资)FROM 职工表; GROUP BY 部门号 SET COUNT(*)>=3 SELECT 部门号,COUNT(*),SUM(工资)FROM 职工表; GROUP BY 部门号 WHERE COUNT(*)>=3