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 <[EMAIL PROTECTED]>
02/18/2005 03:26 AM
To: "MaxDB mailing list." <[email protected]>
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/[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
