電子工業出版社 SHING HOUSE DF ELECTRONY 【例6.13】从样例数据库pubs的 titles表中查询书价( price列)大于15的所有图书 USE pub SELECT title, price WHERE price>15 运行结果: The Busy Executive s Database Guide Straight Talk About Computers Silicon Valley Gastronomic Treats Secrets of Silicon Valley 20.0000 Computer Phobic AND Non-Phobic Individuals: Behavior variations Prolonged Data Deprivation: Four Case Studie 19. Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean (所影响的行数为8行) 查询结果显示表ttes中书价大于15的所有的图书。 【例614】从样例数据库pubs的tes表中查询书籍类型(type列)为 business的所有 图书 USE pubs SeLECt title, type titl e type= business 行结果 title type The Busy Executive s Database Guide Cooking with Computers: Surreptitious Balance Sheets business You Can Combat Computer Stress! Straight Talk About Computers business (所影响的行数为4行) 查询结果显示表tls中书籍类型(type列)为 business的所有图书。 【例615】从样例数据库pubs的tits表中查询书价( price列)在15与20之间的所 有图书。【例 6.13】从样例数据库 pubs 的 titles 表中查询书价（price 列）大于 15 的所有图书。 USE pubs SELECT title, price FROM titles WHERE price>15 运行结果： title price -------------------------------------------------------------------------------- The Busy Executive's Database Guide 19.9900 Straight Talk About Computers 19.9900 Silicon Valley Gastronomic Treats 19.9900 But Is It User Friendly? 22.9500 Secrets of Silicon Valley 20.0000 Computer Phobic AND Non-Phobic Individuals: Behavior Variations 21.5900 Prolonged Data Deprivation: Four Case Studies 19.9900 Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean 20.9500 （所影响的行数为 8 行） 查询结果显示表 titles 中书价大于 15 的所有的图书。 【例 6.14】从样例数据库 pubs 的 titles 表中查询书籍类型（type 列）为 business 的所有 图书。 USE pubs SELECT title, type FROM titles WHERE type='business' 运行结果： title type ------------------------------------------------------------------- The Busy Executive's Database Guide business Cooking with Computers: Surreptitious Balance Sheets business You Can Combat Computer Stress! business Straight Talk About Computers business （所影响的行数为 4 行） 查询结果显示表 titles 中书籍类型（type 列）为 business 的所有图书。 【例 6.15】从样例数据库 pubs 的 titles 表中查询书价（price 列）在 15 与 20 之间的所 有图书