设图书馆数据库中包括3个表:图书表 Book(Bno,Bname,Writer,Pub,Price),读者表Reader(Rno,Rname,Rsex,Rtel,Rdep),借阅表Loan(Rno,Bno,Lday,Rday). 要求查阅借阅图书本数超过2本的读者号、总本数,并按借阅本数值从大到小排序。请将SQL程序段填写完整: SELECT ( ) FROM ( ) GROUP BY ( ) HAVING COUNT(*)>2 ORDER BY ( );
手机使用
分享
复制链接
新浪微博
分享QQ
微信扫一扫
微信内点击右上角“…”即可分享
反馈
参考答案:
举一反三
【单选题】I hope to go to Mexico. I love the place the people are really friendly and warm. [ ]