1> select 学号,姓名,性别 from XS where 姓名 like '王%' 2> select top 5 学号,姓名,总成绩 from XS,CJ where 学生表.学号=成绩表.学号 and 学号 is not(select 学号 from 成绩表 where 成绩<75) group by 成绩表.学号 having count(*)
二题的另一种写法: select top 5 学号,姓名,总成绩 from XS inner join CJ on 学生表.学号=成绩表.学号 where 学号 is not(select 学号 from 成绩表 where 成绩<75) group by 成绩表.学号 having count(*)
题1.select XH,XM,XB from XS where XM='王%' 题2.select XH,XM,sum(CJ),count(*)from XS,CJ where XS.XH=CJ.XH AND XH NOT IN(select XH from CJ where CJ<=75) group by XH having count(*)=5