皮皮学，免费搜题
登录
搜题
【单选题】
在“图书管理”数据库中，查询只借一本图书的读者的姓名和职称。正确的SQL语句是( )。A.
SELECT 姓名,职称 FROM 读者 WHERE 借书证号 NOT IN(SELECT 借书证号 FROM 借阅 GROUP BY 借书证号 HAVING COUNT([＜sup＞*＜/sup＞])=1)
B.
SELECT 姓名,职称 FROM 读者 WHERE 借书证号 IN(SELECT 借书证号 FROM 借阅 GROUP BY 借书证号 HAVING COUNT([＜sup＞*＜/sup＞])=1)
C.
SELECT 姓名,职称 FROM 读者 WHERE 借书证号 IN(SELECT 借书证号 FROM 借阅 GROUP BY 借书证号 WHERE COUNT([＜sup＞*＜/sup＞])=1)
D.
SELECT 姓名,职称 FROM 读者 WHERE 借书证号 IN(SELECT 借书证号 FROM借阅 ORDER BY 借书证号 HAVING COUNT([＜sup＞*＜/sup＞])=1)
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
皮皮学刷刷变学霸
举一反三
【单选题】The noise was so ______ that he was so ______ that he stayed awake the whole night.
A.
disturbing; disturbed
B.
disturbed; disturbing;
C.
disturbing; disturbing
D.
disturbed; disturbed
【简答题】At a Trade Show S=Salesman; I=Importer S: Good morning. Can I help you? I : I wonder if you can give me specific information about this computer model you're ___1___ ? S : I'd be happy to help. I: Tha...
相关题目：