好像不太对啊! 请问在SQL语言里,table和view是不是不一样的啊?? 我后来试出了最后答案,是:drop view secondview; CREATE VIEW secondview as select empno from employee where empno<5; select * from secondview;我只能使用下面的这些命令: You can use select,drop view,create view, cat, and describe only.因为是view而不是table,所以我不能使用insert命令,那么我怎样才能对选出来的栏目内容进行编号呢?? 请帮帮忙吧!!谢谢了!
要求和题目不一样啊,要求是创建一个VIEWCREATE VIEW secondview as select distinct empno from employee where empno<5; select * from secondview;题目说是建一个新表 create table new_table as select * from source_table;
请问在SQL语言里,table和view是不是不一样的啊??
我后来试出了最后答案,是:drop view secondview;
CREATE VIEW secondview as
select empno from employee where empno<5;
select * from secondview;我只能使用下面的这些命令:
You can use select,drop view,create view, cat, and describe only.因为是view而不是table,所以我不能使用insert命令,那么我怎样才能对选出来的栏目内容进行编号呢??
请帮帮忙吧!!谢谢了!
select distinct empno from employee where empno<5;
select * from secondview;题目说是建一个新表
create table new_table as select * from source_table;