Does Trafodion support to use 'order by' in a subquery

["Liu, Ming (Ming)" <mi...@esgyn.cn>]

Hi, all,

I don't know if this is same in other database, but in Trafodion, if I want to have a subquery which have a 'order by', it seems not allowed. Is this normal or a limitation in Trafodion?
For example:

create table t1 ( c1 int, c2 int);

select * from (
   Select * from t1 order by c1);
*** ERROR[15001] A syntax error occurred at or before:
select * from (select * from t1 order by c1);
                                           ^ (44 characters from start of SQL statement)

Thanks in advance,
Ming