dddd

PB做的学生管理系统

SELECT  s.sno ,
           s.sname ,
           s.csrq ,
           s.email ,
           s.sex
        FROM s,sc   
        WHERE  s.sno=sc.sno and  
               sc.cno like :p_cno+'%' and 
               sc.score is null
        ORDER BY s.sno          ASC  


select sc.cno,c.cname,sc.score,c.credit
from sc,c
where  sc.sno= and sc.cno=c.cno
order by sc.cno