数据库SQL查询语句如下：
create view grade_student(学号,姓名,选课门数,平均分,最高分,最低分)
as
select sc.sno,sname,count(cno),avg(grade),max(grade),min(grade)
from sc,student
where student.sno=sc.sno
group by sname,sc.sno
问题：
在最后的GROUP BY 语句加上封号（;）作为语句完结 为什么就不能运行了 不加却可以
设置问题？
加上;是可以的噢
SQL code:
'可以运行啊...'
if object_id('tb')is not null drop table tb
if object_id('test')is not null drop view test
go
create table tb
(
id int,
date datetime
)
go
alter table tb add default getdate() for date
go
insert into tb(id) select 1
union all select 3
union all select 2
union all select 4
go
create view test
as
select id,date=max(date) from tb
group by id;
go
select * from test
/*
id date
---------------------------------
1 2010-04-26 12:42:53.827
2 2010-04-26 12:42:53.827
3 2010-04-26 12:42:53.827
4 2010-04-26 12:42:53.827
*/
你不会每句都加吧 直接是可以的
sql server不用加 ；
请切换输入法
create view grade_student(学号,姓名,选课门数,平均分,最高分,最低分)
as
select sc.sno,sname,count(cno),avg(grade),max(grade),min(grade)
from sc,student
where student.sno=sc.sno
group by sname,sc.sno
--><
