1 . 子句
KarenMorton Oracle 正版計(jì)算機(jī) ... ... Set Transaction(設(shè)置事務(wù)) HAVING子句 B-樹索引.
2 . 所有
havildar 陸軍士官長(zhǎng)having所有havoc 大破壞
3 . 舉行
the children were less than happy about havinga party ., 孩子們對(duì)舉行聚會(huì)并不那么開(kāi)心.
4 . 玩
My friends have been flying up and down Nile havingthe time of their lives ., 我的那群朋友沿著尼羅河飛來(lái)飛去 , 玩得痛快極了.
使用 HAVING 子句選擇行 HAVING 子句對(duì) GROUP BY 子句設(shè)置條件的方式與 WHERE 子句和 SELECT 語(yǔ)句交互的方式類似。WHERE 子句搜索條件在進(jìn)行分組操作之前應(yīng)用;而 HAVING 搜索條件在進(jìn)行分組操作之后應(yīng)用。HAVING 語(yǔ)法與 WHERE 語(yǔ)法類似,但 HAVING 可以包含聚合函數(shù)。HAVING 子句可以引用選擇列表中出現(xiàn)的任意項(xiàng)。 下面的查詢得到本年度截止到目前的銷售額超過(guò) $40,000 的出版商: USE pubs SELECT pub_id, total = SUM(ytd_sale