Is H2 Database able to make SQL query of the over clause with Aggregate function?

Question

such SQL like

SELECT empno, deptno, 
COUNT(*) OVER (PARTITION BY deptno) DEPT_COUNT FROM emp WHERE deptno IN (20, 30);

is very useful.

I just wonder if in H2, how do we implement the similiar function? Maybe creating a java procedure will work. But will this function be inside the roadmap of H2 database?

Answer 1

There is no support for windowing functions in H2.

This has been discussed recently in the H2 forum:

http://groups.google.com/group/h2-database/browse_thread/thread/3899106a85851de3#