How to create a second table as sorted on one column of first table?

I tried:

  create table second as select * from first order by key;

but didn't work. Any help is greatly appreciated!

David Received on Fri May 15 1998 - 20:24:48 CDT