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;
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;
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';
A、Select Count(1)From Student B、Select Sum(*)From Student C、Selec tAvg(*)From Student D、Select Count(*)From Student
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
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类别