Thanks all for responding. I must've mixed it up with Oracle. Best regards. Alexei Novakov
---------------------------------------------------- Hello Alexei, 'ORDER BY' clauses in sub-selects (as usually used in Oracle for achieving the results you want) never worked for MaxDB/SAP DB. There is only the "trick" of fetching only the first n result rows from a result available. Regards Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Alexei Novakov [mailto:[EMAIL PROTECTED] > Sent: Friday, February 18, 2005 9:26 AM > To: MaxDB mailing list. > Subject: 'select * from (select * from table order by field)' > doesn't work > > Hello, > > I'm running MaxDB 7.5.0.18 on Windows. In order to get > first several ordered records I use usual query: > > select * from > ( > select * from > some_table > order by some_column > ) > where rowno < 2 > > I get the error here: > > * -5016: Missing delimiter: ) SQLSTATE: 42000 > > Obviously it doesn't like 'order by' clause in > subselect, as soon as I remove it like: > > select * from > ( > select * from > some_table > ) > where rowno < 2 > > It works fine, but it's not what I need. I have some > feeling that such queries were working in older > versions of SAPDB/MaxDB. Is there some tricks to do to > make it work? Or maybe there is other way to get > limited sorted output in MaxDB? > > Thank you. > > Alexei -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
