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

Alexei,

>From what I understand, things like "Order by" aren't even an official 
part of the SQL specification, and are often-times handled on the client 
(See "SQL for Smarties", ISBN 1-55860-576-2). 

On some engines, you can do something like "Select top 100 * from table 
where field_x= const_y"  I don't recall whether this works in SAPDB or 
not.


Thank you,
      Noah Silva
      Arkema IS&T - Sr. Programmer Analyst
      (215) 419 - 7916





Alexei Novakov <alexei-novakov@xxxxxxxxxx>
02/18/2005 03:26 AM

 
        To:     "MaxDB mailing list." <maxdb@xxxxxxxxxxxxxxx>
        cc: 
        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=noah.silva@xxxxxxxxxxx





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