Hi,
I tried to use CREATE TABLE AS and ORDER BY. The query is as followed:
create table freshhr21 as
select e.studentid, u.hoursxfer
from enrollmentstatus e, undergradclass u
where e.studentid = u.studentid and e.classtd = '1'
order by u.hoursxfer
But, it returns error message "ERROR: parser: parse error at or near
"order"". Does "create table as" support "order by" inside of it?
I am using PostgreSQL 6.5.3.
Thank you.
Joy Chuang
