| -- join between two subqueries | |
| -- both of the subqueries have a window function with only "partition by clause" | |
| select * from | |
| ( | |
| select | |
| b1, | |
| sum(a1) over (partition by b1) | |
| from t1 | |
| ) as sq1(b1, sum_a1) | |
| inner join | |
| ( | |
| select b2, | |
| sum(a2) over (partition by a2,b2,c2 order by a2 desc) | |
| from t2 | |
| ) as sq2(b2, sum_a2) | |
| on (sq1.b1 = sq2.b2); |