题目内容

只要期未股东权益大于期初股东权益,就说明通过企业经营使资本增值

A. 对
B. 错

查看答案
更多问题

查询所有的男性学生姓名和年龄,按照年龄降序排列,可以使用的查询语句是:( )

A. SELECT Sname, Sage FROM Student WHERE Ssex = '男' ORDER BY Sage ASC;
B. SELECT Sname, Sage FROM Student WHERE Ssex = '男' ORDER BY Sage DESC;
C. SELECT Sname, Sage FROM Student WHERE Ssex = '男' ORDER BY Sage;
D. SELECT Sname, Sage FROM Student ORDER BY Sage WHERE Ssex = '男';

查询选修了数学课(课程号为2)的学生人数,可以使用的查询语句是:

A. SELECT MAX(*) FROM SC WHERE Cno = 2;
B. SELECT AVG(Sno) FROM SC WHERE Cno = 2;
C. SELECT COUNT(*) FROM SC WHERE Cno = 2;
D. SELECT COUNT(Sname) FROM SC WHERE Cno = 2;

查询被选修过的课程数量,可以使用的查询语句是:( )

A. SELECT COUNT(DISTINCT Cno) FROM SC;
B. SELECT AVG(DISTINCT *) FROM SC;
C. SELECT COUNT(ALL Cno) FROM SC;
D. SELECT COUNT(*) FROM SC;

查询最低成绩大于85分的学生学号和平均成绩,可以使用的查询语句是:( )

A. SELECT Sno, AVG(Grade) FROM SC HAVING MIN(Grade) > 85 GROUP BY Sno;
B. SELECT Sno, AVG(Grade) FROM SC GROUP BY Sno HAVING MIN(Grade) > 85;
C. SELECT Sno, AVG(Grade) FROM SC WHERE MIN(Grade) > 85 GROUP BY Sno;
D. SELECT Sno, AVG(Grade) FROM SC GROUP BY Sno WHERE MIN(Grade) > 85;

答案查题题库