皮皮学，免费搜题
登录
搜题
【单选题】
设成绩表包含学号、分数等字段。现有查询要求：查询有3门以上课程的成绩在90分以上的学生学号及90分以上课程数。以下SQL语句中正确的是______。A.
SELECT 学号 , COUNT(*) FROM 成绩 WHERE 分数 >90 GROUP BY 学号 HAVING COUNT(*)>3;
B.
SELECT 学号 , COUNT( 学号 ) FROM 成绩 WHERE 分数 >90 AND COUNT( 学号 )>3;
C.
SELECT 学号 , COUNT(*) FROM 成绩 GROUP BY 学号 HAVING COUNT(*)>3 AND 分数 >90;
D.
SELECT 学号 , COUNT(*) FROM 成绩 WHERE 分数 >90 AND COUNT(*)>3 GROUP BY 学号 ;
手机使用
分享
复制链接
新浪微博
分享QQ
微信扫一扫
反馈参考答案：
举一反三
【单选题】'There is nothing new under the sun' really implies that
A.
a new thing can only be created at the basis of earliest things
B.
a new thing is only a tale
C.
we can seldom create new things
D.
we can hardly see really new things in the world
【单选题】Several new railways are under _____ in China .
A.
construction
B.
condition
C.
surrounding
D.
discussion
【简答题】根据《现金管理暂行条例》规定,下列经济业务中,可以使用现金支付的是( )。 【加入题库收藏夹】 A 、支付某职工奖金1 050元 B 、支付零星办公用品购置费1 200元 C 、支付物资采购货款9 300元 D 、支付出差人员必须随身携带的差旅费5 000元
【单选题】To begin with, company policies will remain the ______ under the new management as they have been until now.
A.
equal
B.
similar
C.
same
D.
even
【简答题】Chinese netizens who like to create and use cyber words such as 'geilivable' might find a new regulation very 'ungeilivable'． The new regulation by the General Administration of Press and Publication ...
【简答题】Under our new program, families with incomes of【L11】______will no longer
【单选题】Their ______ -- that their project under way was something entirely new proved to be untrue.
A.
repetition
B.
assumption
C.
impression
D.
comparison
【单选题】Under what conditions can the EPA put off its action?
A.
No new regulations.
B.
No new president and Congress.
C.
No appropriate technology.
D.
No swift proceeding.
【单选题】The new bridge _____ by the famous architect is _____ now. [ ]
A.
designing, under construction
B.
designed, under construction
C.
being designed, under construction
D.
has been designed, under the construction
相关题目：
参考解析：
知识点：
题目纠错 0
发布
