A bypass is to use a table producing function that sorts the result before returning. regards, Martin

On 8/13/13 9:38 PM, Stefan Manegold wrote:

MonetDB does not support order in sub-queries (mainly as order by has no semantically relevant meaning, but is rather for result rendering).

Having said that, you query should work just fine without order by.

Stefan

----- Original Message -----

...

Hi,

I try to execute a query like following:

When I execute, select table_name from system order by table_name; no syntax error.

But when I execute, select count(*) from (select table_name from system order by table_name) as count;

I get syntax error, unexpected ORDER, expecting INTERSECT or EXCEPT or UNION or ')' in: "select count(*) from (select table_name from system order"

What is the correct syntax?

Regards, Ravi

---

users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list