電子工業出版社 JEUISHING HOUSE DF ELECTRONCS INDSTR FROM titles Where type In (business,' psychology') 运行结果 title The Busy Executive s Database Guide Cooking with Computers: Surreptitious Balance Sheet You Can Combat Computer Stress business Prolonged Data Deprivation: Four Case Studies psychology Emotional Security: A New Algorithm psychology (所影响的行数为9行) 查询结果显示表tt中书籍类型为 business和 psychology的所有图书。 【例618】从样例数据库pubs的ts表中查询书籍类型不为 business和 psychology的 所有图书 SELECt title, type FROM titles Where type NOT IN (business, psychology 运行结果: Silicon Valley Gastronomic Treats The Gourmet Microwave The Psychology of Computer Cooking UNDECIDED Fifty Years in Buckingham Palace Kitchens trad_ cook Sushi, Anyone? trad cook (所影响的行数为9行) 查询结果显示表tls中书籍类型不为 business和 psychology的所有图书 【例619】从样例数据库pubs的ts表中查询书名ttle列)以S开头的的所有图书。 USE pubs SeLECt title, type ROM titleFROM titles WHERE type IN ('business', 'psychology') 运行结果： title type ----------------------------------------------------------------------------- The Busy Executive's Database Guide business Cooking with Computers: Surreptitious Balance Sheets business You Can Combat Computer Stress! business ... ... Prolonged Data Deprivation: Four Case Studies psychology Emotional Security: A New Algorithm psychology （所影响的行数为 9 行） 查询结果显示表 titles 中书籍类型为 business 和 psychology 的所有图书。 【例 6.18】从样例数据库 pubs 的 titles 表中查询书籍类型不为 business 和 psychology 的 所有图书。 USE pubs SELECT title, type FROM titles WHERE type NOT IN ('business', 'psychology') 运行结果： title type ----------------------------------------------------------- Silicon Valley Gastronomic Treats mod_cook The Gourmet Microwave mod_cook The Psychology of Computer Cooking UNDECIDED ... ... Fifty Years in Buckingham Palace Kitchens trad_cook Sushi, Anyone? trad_cook （所影响的行数为 9 行） 查询结果显示表 titles 中书籍类型不为 business 和 psychology 的所有图书。 【例 6.19】从样例数据库 pubs 的 titles 表中查询书名(title 列)以 S 开头的的所有图书。 USE pubs SELECT title, type FROM titles