blob: c0eaf6e242eafb3abdb8fedf3bad9c66ea600611 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
table empsalary : { Depname : string,
Empno : int,
Salary : int }
fun main () : transaction page =
x <- queryX (SELECT empsalary.Depname, empsalary.Empno, empsalary.Salary,
RANK() OVER (PARTITION BY empsalary.Depname ORDER BY empsalary.Salary DESC) AS R,
AVG(empsalary.Salary) OVER (PARTITION BY empsalary.Depname) AS A
FROM empsalary)
(fn r => <xml>{[r.Empsalary.Depname]}, {[r.Empsalary.Empno]}, {[r.Empsalary.Salary]}, {[r.R]}, {[r.A]}<br/></xml>);
return <xml><body>
{x}
</body></xml>
|
