查询所有学生选课的信息

2024-12-01 04:46:23
推荐回答(2个)
回答(1):

SELECT student.[学号(sno)], student.[姓名(sname)], student.[性别(sex)], student.[年龄(age)], student.[所在系(dept)], sc.cno, sc.grade FROM student, sc WHERE student.[学号(sno)]=sc.sno;

回答(2):

select jiben,xuanke from biao where student="yixuanxingming";