單項(xiàng)選擇題下列哪一項(xiàng)表示求數(shù)據(jù)表的行數(shù)或某個(gè)列下的值個(gè)數(shù)()

A.Sum()
B.Max()
C.Avg()
D.Count()


您可能感興趣的試卷

你可能感興趣的試題

1.單項(xiàng)選擇題下列利用SC表的查詢語句中,錯(cuò)誤的是()

A.SELECT Sno,COUNT(*)FROM SC GROUP BY Sno
B.SELECT Sno FROM SC GROUP BY Sno HAVING COUNT(*)>3
C.SELECT Sno FROM SC GROUP BY Sno WHERE COUNT(*)>3
D.SELECT Sno FROM SC GROUP BY Sno

2.單項(xiàng)選擇題SELECT...INTO...FROM語句的功能是()

A.將查詢結(jié)果插入到一個(gè)新表中
B.將查詢結(jié)果插入到一個(gè)已建好的表中
C.合并查詢的結(jié)果
D.向已存在的表中添加數(shù)據(jù)