数据库题目 T3如何设置库存期初数量

数据库题目 1、查和“S0701026”读者借了相同图书的读者的图书证号和姓名select rno，rn from reader where rno in(select a.rno from borrow as a，borrow as b where a.bno=b.bno and b.rno='S0701026')2、查询每个读者的姓名和所借图书名select rn，bn from reader，borrow，book where reader.rno=borrow.rno and borrow.bno=book.bno3、查没有借书的读者的图书证号和姓名select rno，rn from reader where rno not in(select rno from borrow)4、查询借阅了“数据结构”的读者数量select count(*)from borrow where bno=(select bno from book where bn='数据结构')group by bno5、查“李丽”和“张朝阳”都借阅了的图书的书号select a.bno from borrow as a，borrow as b where a.rno=(select rno from reader where rn='李丽')and b.rno=(select rno from reader where rn='张朝阳')and a.bno=b.bno6、查询借书上限最大的读者信息select*from reader where rup=(select max(rup)from reader)order by rup desc7、查询借阅图书数量达到2本的读者信息select*from reader where rno in(select rno from borrow group by rno having count(*)>；1)8、查询每个读者姓名，所借图书。

#T3如何设置库存期初数量#用友t3库存期初录入