摘要: The most frequently used wildcard is the percent sign (%). Within a search string, % means match any number of occurrences of any character. For example, to find all products that start with the wor... 阅读全文
posted @ 2009-02-17 11:49 AlexusLi 阅读(316) 评论(3) 推荐(0) 编辑
摘要: SELECT prod_name, prod_price FROM Products WHERE vend_id = 'DLL01' OR vend_id = 'BRS01' AND prod_price >= 10; prod_name prod_price ------------------- ---------- Fish bean ba... 阅读全文
posted @ 2009-02-17 11:00 AlexusLi 阅读(1050) 评论(2) 推荐(0) 编辑