RE: 'select * from (select * from table order by field)' doesn't work

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:alexei-novakov@xxxxxxxxxx] 
> 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/maxdb?unsub=alexander.schroeder@xxxxxxx
> 
> 

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx