|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
AW: Problem with rownum
From: Zabach, Elke (elke.zabach
sap.com)
Date: Thu Jul 15 2004 - 04:42:43 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Fabio Pinotti wrote:
>
> Hi,
> is it possible to run a query like this (Oracle mode)?
>
> "Select rownum+1 from table"
>
>
> SqlStudio gives me the following error:
>
> General error;-7036 POS(17) ROWNO specification not allowed in this
> context.
>
As the kernel tells you with its error-code: it is not possible.
You may do
Select rownum from table
But you are not allowed to use rownum in an expression
Elke
SAP Labs Berlin
>
> Thanks
> Fabio Pinotti
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]