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