'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=gcdm-maxdb@xxxxxxxxxxx