用的地面灌溉方式有畦灌、()、水稻格田灌溉以及漫灌等。
A.沟灌
B.喷灌
C.滴灌
D.微灌
参考答案:A
题中假定学生关系是S(S#,SN.,SEX,AGE),课程关系是C(C#,CNAME,TEACH-ER),学生选课关系是SC(S#,C#,GRADE)。
检索选修四门以上课程的学生总成绩(不统计不及格的课程),并要求按总成绩降序排列出来,正确的SELECT语句是______。
A.SELECT S#,SUM(GRADE)FROM SCWHERE GRADE>=60CROUP BY S#ORDER BY 2 DESCHAVING COUNT(*)>=4
B.SELECT S#,SUM(GRADE)FROM SCWHERE GRADE>=60GROUP BY S#HAVING COUNT(*)>=4ORDER BY 2 DESC
C.SELECT S#,SUM(GRADE)FROM SCWHERE GRADE>=60HAVING COUNT(*)>=4GROUP BY S#ORDER BY 2 DESC
D.DELECT S#,SUM(GRADE)FROM SCWHERE GRADE>=60ORDER BY 2 DESCCROUP BY S#HAVING COUNT(*)>=4
紫外可见分光光度计根据什么原理设置?