搜题
用户您好, 请在下方输入框内搜索其它题目:
搜题
题目内容 (请给出正确答案)
提问人:网友 发布时间:
【判断题】

SELECT COUNT(DISTINCT Sno) FROM  SC 语句用于统计学生的总人数。

更多“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;  DD.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;  DSELECT 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';  DSELECT 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  DSelect 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  DSELECT 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类别  

点击查看答案
客服
TOP

请使用微信扫码支付

订单号:
遇到问题请联系在线客服