-- 先把“林青或陈晨”看成一组,再共同要求价格小于70SELECT Title, Author, PriceFROM dbo.BookWHERE (Author = N'林青' OR Author = N'陈晨') AND Price < 70;
结果是SQL入门和Python基础,不含79元的数据库原理。
4 范围与列表
-- BETWEEN包含两个端点:35元和59元的图书也在内SELECT Title, Price FROM dbo.BookWHERE Price BETWEEN 35 AND 59;-- IN表示编号属于这份列表,等价于三个相等条件用OR连接SELECT BookId, Title FROM dbo.BookWHERE BookId IN (1, 3, 6);-- NOT把条件取反;这里得到单价不在35到59范围内的图书SELECT Title, Price FROM dbo.BookWHERE NOT (Price BETWEEN 35 AND 59);
本节练习
查价格至少60、但小于80的书;查编号为2或4的书;用BETWEEN查库存8—15本的书。
对照答案
SELECT Title, Price FROM dbo.BookWHERE Price >= 60 AND Price < 80; -- Python基础、数据库原理SELECT Title FROM dbo.BookWHERE BookId IN (2, 4); -- Python基础、唐诗选读SELECT Title, Stock FROM dbo.BookWHERE Stock BETWEEN 8 AND 15; -- Python基础、数据库原理、唐诗选读