2013数据库的查询6.pptVIP

  项目五  WebShop数据库的查询 课堂练习1 查询海尔电冰箱HDFX01、劲霸西服、摩托罗拉W380的 商品价格、商品折扣 SELECT g_Name 商品名称, g_Price 商品价格,g_Discount 商品折扣 FROM Goods WHERE g_Name IN (海尔电冰箱HDFX01 , 劲霸西服, 摩托罗拉 W380) Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 【任务1-2-8】（模糊查询）了解所有商品中“三星”的商品的详细信息。 [NOT] LIKE “匹配串’’[ ESCAPE“换码字符”] SELECT * FROM Goods WHERE g_Name LIKE 三星% Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 【任务1-2-9】（模糊查询