Is an H2 database capable of executing an SQL query on an over clause with an Aggregate function?

SQL like

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

very helpful.

I'm just wondering, in H2, how do we implement a similar function? Perhaps creating a java procedure will work. But will this feature be inside the H2 database roadmap?

+3
source share
1 answer

There is no window function support in H2.

This was recently discussed on the H2 forum:

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

+3
source

All Articles