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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
