本文共 367 字，大约阅读时间需要 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