1、从图书表Book表中查询定价在20到30元之间的图书信息
use Library
select * from Book where Price>=20 and Price<=30
go
或
use Library
select * from Book where Price Between 20 and 30
go
2 从借阅表中查询出没有还书的读者信息
use Library
select * from Reader,Borrow where ReturnDate is null and Reader.RID=Borrow.RID
go
3、查询借阅“人民出版社”出版的图书的读者(不包含重复列)
use Library
select distinct Reader.* from Reader,Book,Borrow where PubComp='人民出版社' and Book.BID=Borrow.BID and Borrow.RID=Reader.RID
go
4、查询没有借过书的读者信息
use Library
select * from Reader,Borrow where Reader.RID!=Borrow.RID
go
评论0
最新资源