Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
AW: Problem with rownum
From: Zabach, Elke (elke.zabachsap.com)
Date: Thu Jul 15 2004 - 04:42:43 CDT
Fabio Pinotti wrote:
> 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
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
SAP Labs Berlin
> Fabio Pinotti
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb