so_damn_insane's Journal
[Most Recent Entries]
[Calendar View]
[Friends View]
Wednesday, September 24th, 2008
Time |
Event |
3:43p |
| 4:10p |
| 5:50p |
kaut kas jauns un jauks Ilustrējam atšķirību starp RANK un DENSE_RANK.
SELECT dense_rank(3) within group (order by v2 ) FROM ( select 1 as v2 from dual union all select 2 as v2 from dual union all select 2 as v2 from dual union all select 4 as v2 from dual union all select 5 as v2 from dual);
SELECT rank(3) within group (order by v2 ) FROM ( select 1 as v2 from dual union all select 2 as v2 from dual union all select 2 as v2 from dual union all select 4 as v2 from dual union all select 5 as v2 from dual); |
|