電子工業出版社 JEUISHING HOUSE DF ELECTRONCS INDSTR USE pubs SELECT title, price RoM title Where price BETWEEN 15 AND 20 行结果 title price The Busy Executive s Database Guide 19.9900 raight Talk About Computers 19.9900 Silicon Valley Gastronomic Treats Secrets of silicon Valley Prolonged Data Deprivation: Four Case Studies 19.9900 (所影响的行数为5行) 查询结果显示表 titles中书价在15与20之间的所有图书。 【例616】从样例数据库pubs的ttes表中查询书价( price列)不在15与20之间的 所有图书 SeleCt title, price FROM titles Where price NOT BETWEEN 15 AND 20 price Cooking with Computers: Surreptitious Balance Sheets 11 9500 You Can Combat Computer Stress! The gourmet microwave Fifty Years in Buckingham Palace Kitchens Sushi, Anyone? 14.9900 (所影响的行数为11行) 查询结果显示表 titles中书价不在15与20之间的所有图书。 【例617】从样例数据库pubs的 titles表中查询书籍类型为 business和 psychology的所 有图书 USE pubs SeLECt title, typeUSE pubs SELECT title, price FROM titles WHERE price BETWEEN 15 AND 20 运行结果 title price ----------------------------------------------------------- The Busy Executive's Database Guide 19.9900 Straight Talk About Computers 19.9900 Silicon Valley Gastronomic Treats 19.9900 Secrets of Silicon Valley 20.0000 Prolonged Data Deprivation: Four Case Studies 19.9900 （所影响的行数为 5 行） 查询结果显示表 titles 中书价在 15 与 20 之间的所有图书。 【例 6.16】从样例数据库 pubs 的 titles 表中查询书价（price 列）不在 15 与 20 之间的 所有图书。 USE pubs SELECT title, price FROM titles WHERE price NOT BETWEEN 15 AND 20 title price ------------------------------------------------------------------------ Cooking with Computers: Surreptitious Balance Sheets 11.9500 You Can Combat Computer Stress! 2.9900 The Gourmet Microwave 2.9900 ... ... Fifty Years in Buckingham Palace Kitchens 11.9500 Sushi, Anyone? 14.9900 （所影响的行数为 11 行） 查询结果显示表 titles 中书价不在 15 与 20 之间的所有图书。 【例 6.17】从样例数据库 pubs 的 titles 表中查询书籍类型为 business 和 psychology 的所 有图书。 USE pubs SELECT title, type