sql 想查询到2条记录
发布网友
共1个回答
热心网友
select sno,cno,grade
from sc T1,(select sno, max(grade) mgrade from sc group by sno) T2
where T1.sno=T2.sno and T1.grade=T2.grade
