大家好,我是知数堂SQL 优化班老师 网名:骑龟的兔子
很久没有写文章,最近碰到了一个非常有意思的Oracle SQL 案例,
这个案例,我用了一些窗口函数来解决的,后来想想,能否跟MySQL
有所关联,就用一个SQL,总结了@的常用用法。
首先我们看下,如下案例
with w1 as ( select 1 rn , 'cityhp01' mber_id from dual union all select 2 , 'uvis6921' mber_id from dual union all select 3 , 'uvis6921' mber_id from dual union all select 4 , 'moonhwa119' mber_id from dual union all select 5 , 'moonhwa119' mber_id from dual union all select 6 , 'b2500795' mber_id from dual union all select 7 , 'b2500795' mber_id from dual union all select 8 , 'b2500795' mber_id from dual union all select 9 , 'dum