查询被借阅过的图书,语句 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)
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)
举一反三
- 查询被借阅过的图书,语句SELECT name from book where____的条件,下列哪一个不能实现。 A: bno =all (select bno from borrow) B: bno =any (select bno from borrow) C: bno in (select bno from borrow) D: exists t(select * from borrow where bno=book.bno)
- 下列两个语句select [name] from book where bno in (select bno from borrow)和select [name] from book where exists ( select * from borrow where borrow.bno=book.bno) 查询结果相同。
- 查询没有借阅图书编号为“b0003”的学生姓名。不能得到正确结果的SELECT语句是( ). A: SELECT 姓名FROM 学生 <br>WHERE NOT EXISTS( SELECT * FROM 借阅 WHERE (学生.学号=学号) AND (书号=’b0003’)) B: SELECT 姓名FROM 学生 WHERE 学号 !=ANY ( SELECT 学号 FROM 借阅 WHERE 书号=’b0003’) C: SELECT 姓名FROM 学生 WHERE 学号 NOT IN ( SELECT 学号 FROM 借阅 WHERE 书号=’b0003’) D: SELECT 姓名FROM 学生 <br>WHERE 学号 !=ALL ( SELECT 学号 FROM 借阅 WHERE 书号=’b0003’)
- 查询“图书”表中书名含有“计算机”的图书信息，正确的选项是______。 A: select * from book where bname like ‘_计算机_’ B: select * from book where bname like ‘_计算机%’ C: select * from book where bname like ‘%计算机_’ D: select * from book where bname like ‘%计算机%’
- 智慧职教: 更新borrow表每条借书记录的eprdate(到期日期)。 borrow eprdate=timestampadd(day,(select maxdays from readertype where typeID in (select typeID from reader where reader.readerID=.)),brwdate);