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}
内容
- 0
假定用户表user有多列，其中字段id中没有null值，字段username中存在null值。下面选项中，不能获得user表的总记录数的SQL语句是（ ） A: select count(*) from user; B: select count(id) from user; C: select count(username) from user; D: select count(id) from user where1=1;
- 1
已知用户表 user 有多列,其中字段 id 没有 NULL 值,字段username有NULL值,选项中,不能获得 user 表的总记录数量的 SQL 语句是 A: SELECT COUNT (*) FROM user ; B: SELECT COUNT ( id ) FROM user ; C: SELECT COUNT ( username ) FROM user ; D: SELECT COUNT ( id ) FROM user WHERE 1=1;
- 2
统计各系男生人数,最准确的SQL语句是(<br/>)。 A: SELECT<br/>COUNT(*) FROM stduents GROUP BY d_no WHERE sex='男' B: SELECT<br/>COUNT(*) FROM students WHERE sex='男'<br/>GROUP BY d_no C: SELECT<br/>COUNT(*) FROM students WHERE sex='男'<br/>ORDER BY d_no D: SELECT<br/>COUNT(*) FROM students HAVING sex='男'<br/>GROUP BY d_no
- 3
把查询语句的各个子句按执行的先后顺序排列，正确的是( ) A: FROM→WHERE→GROUP BY→SELECT→ORDER BY B: SELECT→FROM→WHERE→GROUP BY→ORDER BY C: WHERE→FROM→SELECT→GROUP BY→ORDER BY D: FROM→WHERE→SELECT→ORDER BY→GROUP BY
- 4
按课程号分类，统计相应的选课人数（） A: select cid, count(distinct sid) from sc group by cid B: select cid, count(*) from student group by cid C: select cid, count(distinct cid) from sc group by cid D: select cid, count(distinct sid) from student group by cid