單項選擇題查詢student表中的學生信息,按照姓名降序排列,以下語句操作正確的是()。

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


您可能感興趣的試卷

你可能感興趣的試題

3.單項選擇題以下能查詢student表中age字段的最小值的SQL語句是()。

A.select max(age)from student
B.select min(age)from student
C.select sum(age)from student
D.select avg(age)from student

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

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

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