【判断题】
查看正确答案
搜题
更多“SELECT COUNT（DISTINCT Sno） FROM  SC 语句用于统计学生的总人数。”相关的问题
第2题
A、A.select job from emp; B、B.select job,count(*) from emp; C、C.select distinct job,count(*) from emp; D、D.select job,count(*) from emp group by job; E、E.select job,sum(empno) from emp group by job;
第4题
A、SELECT TOTAL(*) FROM customers; B、SELECT COUNT(*) FROM customers; C、SELECT TOTAL(customer_id) FROM customers; D、SELECT COUNT(customer_id) FROM customers; E、SELECT COUNT(customers) FROM customers; F、SELECT TOTAL(customer_name) FROM customers;
第5题
A、SELECT COUNT(*) FROM employees WHERE last_name='Smith'; B、SELECT COUNT(dept_id) FROM employees WHERE last_name='Smith'; C、SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith'; D、SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith'; E、SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith';
第7题
A、Select Count（1）From Student B、Select Sum（*）From Student C、Selec tAvg（*）From Student D、Select Count（*）From Student
第8题
A、SELECT Sno， COUNT（*） FROM SC GROUP BY Sno B、SELECT Sno FROM SC GROUP BY Sno WHERE COUNT（*）> 3 C、SELECT Sno FROM SC GROUP BY Sno HAVING COUNT（*）> 3 D、SELECT Sno FROM SC GROUP BY Sno
第9题
A、CREATE VIEW v1AS SELECT类别，SUM（数量）FROM商品GROUP BY类别 B、CREATE VIEW v1AS SELECT类别，COUNT（数量）FROM商品GROUP BY类别 C、CREATE VIEW v1（类别，总数量）AS SELECT类别，SUM（数量）FROM商品GROUP BY类别 D、CREATE VIEW v1（类别，总数量）AS SELECT类别，COUNT（数量）FROM商品GROU PBY类别
