如何提高下面语句的效率select * from(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 fromsut_s aleft join cou_c bon a.ll=b.ll where a_month>='10'group by b_
来源:学生作业学帮网 编辑:学帮网 时间:2024/06/06 14:19:07
如何提高下面语句的效率
select * from
(
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
)where rank
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)
如何提高下面语句的效率select * from(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 fromsut_s aleft join cou_c bon a.ll=b.ll where a_month>='10'group by b_
如何提高一下语句的效率SQL语句如下,我用的是ORACLE 10G: select a.name, b.Code EntCode, b.Name EntlName, from WF_Flow a, WF_Model b where a.EntGid = '2000000000000000000000000009087A' and b.EntGid = '200000000000
如何提高电机的效率
如何提高做事的效率.
如何提高柴油机的效率
如何提高内燃机的效率
如何提高电机的效率
如何提高做事的效率?
如何提高听课的效率?
如何提高背诵的效率
如何提高背诵的效率?
如何提高记忆的效率
如何提高旋流器的效率
如何提高球磨机的效率?
如何提高直流电机的效率?
如何提高热机的效率?急
如何提高初中物理的课堂教学效率?
如何提高作数学题的效率?