下列两个语句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) 查询结果相同。
举一反三
- 查询被借阅过的图书,语句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( ) 的条件,下列哪[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: 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 ‘%计算机%’
- 下面查询语句中哪条查询语句会查询出所有包含"李"的数据？ A: select * from student where name limit‘%李%’ B: select * from student where name =‘%李%’ C: select * from student where name like‘%李%’ D: select * from student where name in‘%李%’
- 若想查询student表中name为空值的记录，则正确的SQL语句是（ ）。 A: SELECT * FROM student WHERE name = NULL; B: SELECT * FROM student WHERE name like NULL; C: SELECT * FROM student WHERE name = 'NULL'; D: SELECT * FROM student WHERE name is NULL;