「SQL」having文で集約関数の値に条件を指定する
書式
select カラム名 from テーブル名
group by カラム名
having 条件式
使用例
select
productname
, avg(price)
from
products
group by
productname
having
avg(price) > 100
select
productname
, avg(price)
from
products
group by
productname
having
avg(price) > 100
select productname , avg(price) from products group by productname having avg(price) > 100
結果
ProductName | AVG(price) |
---|---|
Côte de Blaye | 263.5 |