2014Fall.ppt

* SELECT Example (3) Using a Function 可以使用函數對欄位做運算 例如 COUNT(), MAX(), MIN(), SUM(), AVERAGE()…等 依RDBMS不同另有許多擴充函數 Using the COUNT aggregate function to find totals 找出總筆數 SELECT COUNT(*) FROM ORDER_LINE_V WHERE ORDER_ID = 1004; Note: with aggregate functions you can’t have single-valued columns included in the SELECT clause * 是 所有欄位 的簡寫 改以特定欄位亦可 * SELECT Example (4) Boolean Operators AND, OR, and NOT Operators for customizing conditions in WHERE clause SELECT PRODUCT_DESCRIPTION, PRODUCT_FINISH, STANDARD_PRICE FROM PRODUCT_V WHERE (PRODUCT_DESCRIPTION LIKE ‘%Desk’ OR PRODUCT_DESCR