Mercurial > urweb
comparison tests/window.ur @ 1778:818d4097e2ed
Lighter-weight encoding of window function use
author | Adam Chlipala <adam@chlipala.net> |
---|---|
date | Sun, 03 Jun 2012 11:29:31 -0400 |
parents | 59b07fdae1ff |
children |
comparison
equal
deleted
inserted
replaced
1777:59b07fdae1ff | 1778:818d4097e2ed |
---|---|
1 table empsalary : { Depname : string, | 1 table empsalary : { Depname : string, |
2 Empno : int, | 2 Empno : int, |
3 Salary : int } | 3 Salary : int } |
4 | 4 |
5 fun main () : transaction page = | 5 fun main () : transaction page = |
6 x <- queryX (SELECT empsalary.Depname, empsalary.Empno, empsalary.Salary, | 6 x <- queryX (SELECT empsalary.Depname, empsalary.Empno, empsalary.Salary, |
7 RANK() OVER (PARTITION BY empsalary.Depname ORDER BY empsalary.Salary DESC) AS R, | 7 RANK() OVER (PARTITION BY empsalary.Depname ORDER BY empsalary.Salary DESC) AS R, |
8 AVG(empsalary.Salary) OVER (PARTITION BY empsalary.Depname) AS A | 8 AVG(empsalary.Salary) OVER (PARTITION BY empsalary.Depname) AS A |