sql-having

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

 

 SELECT  Store_Name,  SUM  (Sales) 
  FROM   Store_Information 
  GROUP   BY   Store_Name
  HAVING   SUM (sales)  >   1500 ;

 Los Angeles      1800 

 

 

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

 SELECT 
     * 
 FROM  
    report_backup r1
  HAVING  r1.STATE >  1 

 

sql-having

标签：

查看更多关于sql-having的详细内容...