單項選擇題計算stu表中score列平均分數(shù)的sql語句正確的是()。

A.select avg(score)from stu
B.select max(score)from stu
C.select min(score)from stu
D.select sum(score)from stu


您可能感興趣的試卷

你可能感興趣的試題

1.單項選擇題查詢student表中name一列數(shù)據(jù),以下命令正確的是()。

A.select * from student
B.select name from student
C.delete from student
D.update name from student

2.單項選擇題mysql查詢數(shù)據(jù)內(nèi)容命令正確的是()。

A.select * from class
B.drop * from class
C.modify * from class
D.change * from class

3.單項選擇題查詢學生表中的學生信息,按照姓名降序排列()。

A.select * from student order by named esc
B.select * from student order by name asc
C.select * from student group by named esc
D.select * from student group by name

4.單項選擇題計算stu表中score列總分數(shù)的sql語句正確的是()。

A.select avg(score)from stu
B.select max(score)from stu
C.select min(score)from stu
D.select sum(score)from stu