sql语句练习题及答案(2)

select grade from sc where cno=’1002’)

select top 3 sno from sc group by sno order by avg(grade)desc a:select*from student where sdept=’JSJ’ and sage>19

b:select*from student where sdept=’JSJ’ except select* from student where sage<19 select student.sno,sname from student,sc where cno=’1001’ and grade>90 union select sno,sname from student where sno in （ select sno from sc group by sno having avg(grade)>85)

select sno from student where sno not in(select sno from sc x where grade< ( select avg(grade) from sc where cno=x.cno) ) select sname from student x where sage> (

select avg(sage) from student where sdept=x.sdept)

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库sql语句练习题及答案(2)在线全文阅读。