统计每个部门中的人数的语句是【】。
A: SELECT SUM(ID) FROM examp GROUP BY DE_NUM
B: SELECT COUNT(ID) FROM examp ORDER BY DE_NUM
C: SELECT COUNT(ID) FROM examp GROUP BY DE_NUM
D: SELECT SUM(ID) FROM examp ORDER BY DE_NUM
A: SELECT SUM(ID) FROM examp GROUP BY DE_NUM
B: SELECT COUNT(ID) FROM examp ORDER BY DE_NUM
C: SELECT COUNT(ID) FROM examp GROUP BY DE_NUM
D: SELECT SUM(ID) FROM examp ORDER BY DE_NUM
举一反三
- 统计每个部门中人数的语句是？ A: select count(id) from emp order by deptno; B: select sum(id) from emp order by deptno; C: select count(id) from emp group by deptno; D: select sum(id) from emp group by deptno;
- 输出公司的名称及id，以id的升序排列 A: SELECT name, id FROM job ORDER BY id ASC; B: SELECT name, id FROM job ORDER BY id DESC; C: SELECT name, id FROM job ORDER BY name DECS; D: SELECT name, id FROM job ORDER BY name ASC;
- 查询主键id从高到低排序的前10条记录的语句是（） A: SELECT * FROM table ORDER BY id ASC limit 1,10 B: SELECT * FROM table ORDER id DESC limit 10 C: SELECT * FROM table ORDER BY id DESC limit 10 D: SELECT * FROM table ORDER id ASC limit 1,10
- 统计学生成绩中的最高分，下列语句正确的是 A: SELECT AVG(grade) FROM student; B: SELECT (SUM(grade) / Count(id)) FROM student; C: SELECT MAX(grade) FROM student; D: SELECT MIN(grade) FROM student;
- 关于ResultType取值错误的是（） 未知类型：{'options': ['[select id="selectPersonCount" resultType="Integer"]_x000D_ select count(*) from_x000D_ person[/]', '[select id="selectPersonCount" resultType="int"] select count(*) from person[/]', '[select id="selectPersonCount" resultType="_int"] select count(*) from person[/]', '[select id="selectPersonCount" resultType="java.lang.Integer"] select count(*) from person[/]'], 'type': 102}