mysql实战技巧（六）having 语法

  

   

    

     

    
    

     

      SELECT applicationId FROM `light_record` 
     
    
   

    

     

    
    

     

      where applicationId  is not null 
     
    
   

    

     

    
    

     

      group by applicationId having count(applicationId) > 1
     
    
  
 

文章来源: baocl.blog.csdn.net，作者：小黄鸡1992，版权归原作者所有，如需转载，请联系作者。

原文链接：baocl.blog.csdn.net/article/details/103042821