当前位置：Gxlcms > 数据库问题 > sql-having

sql-having

时间：2021-07-01 10:21:17 帮助过：24人阅读

"栏位1", SUM("栏位2") FROM "表格名" GROUP BY "栏位1" HAVING (函数条件);

技术分享

<span style="color: #0000ff;">SELECT</span> Store_Name, <span style="color: #ff00ff;">SUM</span><span style="color: #000000;">(Sales) 
</span><span style="color: #0000ff;">FROM</span><span style="color: #000000;"> Store_Information 
</span><span style="color: #0000ff;">GROUP</span> <span style="color: #0000ff;">BY</span><span style="color: #000000;"> Store_Name
</span><span style="color: #0000ff;">HAVING</span> <span style="color: #ff00ff;">SUM</span>(sales) <span style="color: #808080;">></span> <span style="color: #800000; font-weight: bold;">1500</span>;

<span style="color: #000000;">Los Angeles    </span><span style="color: #800000; font-weight: bold;">1800</span>

请读者注意： GROUP BY 子句并不是一定需要的。

<span style="color: #0000ff;">SELECT</span>
    <span style="color: #808080;">*</span>
<span style="color: #0000ff;">FROM</span><span style="color: #000000;">
    report_backup r1
</span><span style="color: #0000ff;">HAVING</span> r1.STATE<span style="color: #808080;">></span><span style="color: #800000; font-weight: bold;">1</span>

sql-having

标签：

sql-having

人气教程排行