Hi, I think we have a simple error in the release docs for FB 4.0 Beta 1:
Section More Window Functions (Pages: 76-77) Ranking Functions: DENSE_RANK() | RANK() | PERCENT_RANK() | CUME_DIST() | NTILE(<expr>) | ROW_NUMBER() Simple Example The following example illustrates the behaviour of ranking functions. SUM is included for comparison. SQL> select CON> id, CON> salary, CON> dense_rank() over (order by salary), CON> rank() over (order by salary), CON> percent_rank() over (order by salary), CON> cume_dist() over (order by salary), CON> ntile(3) over (order by salary), CON> row_number() over (order by salary), CON> sum(1) over (order by salary) CON> from employee CON> order by salary; Statement failed, SQLSTATE = 42S22 Dynamic SQL Error -SQL error code = -206 -Column unknown -ID -At line 2, column "id" has to be "emp_no". The same for the table. Please verify. I don't have an installation of FB 4.0. Regards, Martin
_______________________________________________ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs