如何提高下面语句的效率select * from( - 知识问答

如何提高下面语句的效率select * from(select a_month ,b_name ,count(DISTI

1个回答

select a_month ,b_name ,count(DISTINCT a.c_no) ,
dense_rank() over (partition by a_month order by COUNT( DISTINCT a.c_no) desc) rank from
sut_s a
left join
cou_c b
on a.ll=b.ll
where a_month>='10'
group by b_name,a_month
having dense_rank() over (partition by a_month order by COUNT( DISTINCT a.c_no) desc)

相关问题