第4题
A.select count(all) from emp;
B.select count(emp_id) from emp;
C.select count(*) from emp;
D.select count(1) from emp;
第7题
A.=COUNT(A2,A6)
B.=COUNT(A2:A6)
C.=SUM(A2:A6)
D.=SUM(A2+A6)
第8题
A.SELECTa+COUNT(*)FROMA
B.SELECTUDF_SYS_COUNT_COLUMN(a)FROMA
C.SELECTSUM(COUNT(*))FROMA
D.以上都正确
第9题
A.SELECT部门号,COUNT(*),SUM(工资)FROM职工HAVINGCOUNT(*)>=3
B.SELECT部门号,COUNT(*),SUM(工资)FROM职工GROUPBY基本工资HAVINGCOUNT(*)>=3
C.SELECT部门号,COUNT(*),SUM(工资)FROM职工GROUPBY部门号HAVINGCOUNT(*)>=3
D.SELECT部门号,COUNT(*),SUM(工资)FROM职工GROUPBY部门号WHERECOUNT(*)>=3
第10题
A.select count(*) from emp
B.select avg(*) from emp
C.select min(*) from emp
D.select max(*) from emp