下列两个语句select[name]frombookwherebnoin(selectbnofromborrow)和select[name]frombookwhereexists(select*fromborrowwhereborrow.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) 查询结果相同。
- 查询被借阅过的图书,语句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)
- 下面正确表示查询goods表中type和name的SQL语句是。 A: select * from goods; B: select type name from goods; C: select type,name from goods; D: select name type from goods;
- 下面查询语句中哪条查询语句会查询出所有包含"李"的数据？ 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‘%李%’