题目是:为学号(sid=12)的学生创建一个视图score_view,包括“sid”、“sex”、“sname”、“department_name”;我这样写怎么不能通过编译:create view score_view
as
select sid,sex,sname,department_name
from student
where sid=12;提示:
第 5 行: ';' 附近有语法错误。高手帮我看看,谢谢,!!!
as
select sid,sex,sname,department_name
from student
where sid=12;提示:
第 5 行: ';' 附近有语法错误。高手帮我看看,谢谢,!!!
as
select sid,sex,sname,department_name
from student where sid=12
create view score_view
as
select sid,sex,sname,department_name
from student
where sid=12
sql语句结束不是要用;号结尾吗????