oracle中按一字段分组后再选出另一字段出现频率最高的

正文摘要:

有一个logs表，如下图所示 具体代码： with x as (select module, dept, COUNT(*) c from logs group by module, dept), xx as (select x.*, RANK() over(partition by module order by x.c desc) rn from ...