有谁会这6个查询数据?请大佬指导。
sqlserver2008吧
全部回复
仅看楼主
level 9
有谁会这6个查询数据?请大佬指导。
2018年06月11日 22点06分 1
level 8
刚看到这个贴子[阴险]还是回复一下
1、select * from students where sAddress='洛杉矶'
2、select * from students where sName like '%詹%'
3、select sID,sName from students where sAddress=!'洛杉矶'
4、select * from students where sID='学号' and sName='姓名' and sAddress='地址'
5、select * from score where cID='c001' order by score desc
6、select AVG(score) as 平均成绩,MAX(score) as 最高成绩,MIN(score) as 最低成绩 from score where cID='c002'
7、select COUNT(*) from score where cID='c002' and score>=60
8、select * from score order by cID compute avg(score) as 平均成绩 by cID
9、select sID,sName,score from score where cID in(select cID from course where cName='数据结构')
10、select sName from course where cID in(select cID from score where cID=c002 and score<80)
2018年10月08日 03点10分 2
1