本文共 375 字，大约阅读时间需要 1 分钟。

   
  
    
???cl_aa????SQL???????????
  1. ??cl_aa????modi_staff_id?jm??????count(*)??numb??
  2. ??modi_staff_id?jm????
  
  
    
    
     
      
      
    
     
  
    
  
    
????SQL?????????????
  SELECT * FROM (
    SELECT 
      ROW_NUMBER() OVER(PARTITION BY jm ORDER BY numb DESC) rn,
      cl_aa.*
    FROM cl_aa
  ) 
  WHERE rn <4;
   
?????https://my.oschina.net/iamchenli/blog/1550011

转载地址：http://llpfk.baihongyu.com/