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
-
W dniu 2013-08-10 09:39:43 użytkownik Mark Rotteveel
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
> >
> > Firebird
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 reco
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 ro
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,
>
>
