SQL语句“select count(*)from employee”,需要SqlCommand对象的哪一个方法在执行()。
A、ExecuteNonQuery()
B、ExecuteScalar()
C、EndExecuteReader()
D、ExecuteXmlReader()
A、ExecuteNonQuery()
B、ExecuteScalar()
C、EndExecuteReader()
D、ExecuteXmlReader()
A、Select Count(1)From Student B、Select Sum(*)From Student C、Selec tAvg(*)From Student D、Select Count(*)From Student
A、A.SELECT AVG(Age) FROM Student B、B.SELECT MAX(Age) FROM Student C、C.SELECT MIN(Age) FROM Student D、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、A.SELECT MIN (年龄) AS 平均 FROM 学生表 B、B.SELECT MAX (年龄) AS 平均 FROM 学生表 C、C.SELECT AVG (年龄) AS 平均 FROM 学生表 D、D.SELECT COUNT (年龄) AS 平均 FROM 学生表
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类别
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;