Hi,
you do not understand me correctly
i talking about query with over() not over(order by)
i know that i can specify many row_number clause in one query
Firebird allow this construction over(without order by) and then it should
numerate records in resultset sequential
Example MSSQL disallow
On 10-8-2013 09:08, liviuslivius wrote:
Hi,
you do not understand me correctly
i talking about query with over() not over(order by)
i know that i can specify many row_number clause in one query
Firebird allow this construction over(without order by) and then it should
numerate records in
W dniu 2013-08-10 09:39:43 użytkownik Mark Rotteveel m...@lawinegevaar.nl
napisał:
On 10-8-2013 09:08, liviuslivius wrote:
Hi,
you do not understand me correctly
i talking about query with over() not over(order by)
i know that i can specify many row_number clause in one query
10.08.2013 21:20, liviuslivius пишет:
and i test this also against Oracle 11g
and try SELECT T.ID, row_Number() over() FROM TEST
i get error the same as in MSSQL
Error: ORA-30485: missing ORDER BY expression in the window specification
PGSQL 9.1:
postgres=# select id from test;
id
Put in your head that:
1) you can have more than one column using ROW_NUMBER, each which
different order
2) no implicit order will be assumed when only one column using
ROW_NUMBER is present
then all your questions will be answered.
Adriano
On 09/08/2013 03:25, liviuslivius wrote:
Hi,
i