sql - 告诉我我缺少右括号 idk 为什么

Question

create table salary_cp 
as 
( select  rownum ,first_name,job_id,salary  from employees   order by salary desc  );

标签： sqloracle

Answer 1

按语句删除订单，然后尝试

 create table salary_cp as 
( select  *  from employees)