从图书馆数据库查询读者的借阅情况的语句正确吗？SELECT Reader.*,RID,BID Borrow FULL OUTER JOIN Reader ON eader.RID=Borrow.RID
举一反三
- 以下语句除了查询满足条件的记录，还显示（）表的所有记录。SELECT Reader.*,Borrow.ReaderIDFROM Reader LEFT OUTER JOIN Borrow ON Reader.ReaderID=Borrow.ReaderID A: Reader B: Borrow C: book
- 以下语句除了查询满足条件的记录，还显示（）表的所有记录SELECT Book.*,Borrow.ReaderIDFROM Borrow RIGHT OUTER JOIN BookON Book. BookID =Borrow. BookID A: Reader B: Borrow C: Book
- 往reader表中插入一个学生 ’2004060003’，’李亚茜’，3（ ）。 A: INSERT into ReaderVALUES('2004060003','李亚茜',3) B: INSERT into Reader(RID,Rname,TypeID)VALUES('2004060003','李亚茜',3) C: INSERT into Reader(RID,Rname,TypeID)VALUES('李亚茜','2004060003',3) D: INSERT into Reader(RID,TypeID,Rname)VALUES('2004060003','李亚茜',3)
- 六、视图和索引（5分，判断以下SQL语句是否正确）2、创建视图查询读者的基本信息及在图书馆借阅记录的主要信息，包括借阅人姓名、地址、图书编号、借阅日期、应归还日期和实际归还日期等信息。create view v_Libraryasselect RName,RAddress,BID,LendDate,WillDate,ReturnDate from Reader,Borrowwhere Reader.RID =Borrow.RID;
- 查询被借阅过的图书,语句 SELECT name from book where( ) 的条件,下列哪[br][/br]一个不能实现. A: no =all (select bno from borrow) B: no =any (select bno from borrow) C: no in (select bno from borrow) D: exists (select * from borrow where bno=book.bno)