Hello Grzegorz, unfortunately MaxDB does not support the infamous 'order by in subquery' feature of Oracle, which is quite frequently used for Oracle with some tricky where clauses to limit the number of rows placed in the result set, and do this *after* an order/group by clause is applied.
Unfortunately, MaxDB has no SQL Syntax that limits the amount of rows returned by a query statement, you will need to use navigation methods on the result set (e.g. with JDBC ResultSet.absolute or similar). Regards Alexander Schröder SAP DB, SAP Labs Berlin > -----Original Message----- > From: Grzegorz Konicki [mailto:[EMAIL PROTECTED] > Sent: Monday, August 02, 2004 11:02 AM > To: [EMAIL PROTECTED] > Subject: problem with clause ORDER > > > Hello > I have a problem with clause "order" > My query looks like: > select * from (select company,rowno as row from clients order > by company) > where row >1 and row < 100 > > and MaxDB return me an error : missing delimiter ) > > Is it possible to use clause "order by" in inner select? > How can i do this.I want to order first and next limit the result. > > > best regards > gregory > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
