select distinct sname,student.sno,cno,score
from student,grade
where student.sno=grade.sno
order by cno
(select min(score)
from grade
where cno=
(select distinct cno
from grade
where cno= '* '));
服务器: 消息 156，级别 15，状态 1，行 5
在关键字 'select ' 附近有语法错误。
服务器: 消息 170，级别 15，状态 1，行 10
第 10 行: ') ' 附近有语法错误。
哪错了？
------解决方案--------------------
这是两个语名:
select distinct sname,student.sno,cno,score
from student,grade
where student.sno=grade.sno
order by cno
(select min(score)
from grade
where cno in--改为in
(select distinct cno
from grade
where cno= '* '))