第十章上机 (SQL)

最新推荐文章于 2021-03-31 16:50:55 发布

qq_36074096

最新推荐文章于 2021-03-31 16:50:55 发布

阅读量1.5k

点赞数 1

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/qq_36074096/article/details/53304142

本文详细介绍了进行SQL上机操作的步骤和技巧，包括数据查询、表操作和复杂查询的实例解析，帮助读者掌握实际数据库操作技能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

--上机练习1
--NO.1
SELECT StudentName,Phone,[Address] FROM Student WHERE Address LIKE '山东%'
--NO.2
SELECT SubjectName,ClassHour,GradeId FROM Subject WHERE SubjectName LIKE '%数据库%' ORDER BY GradeId
--NO.3
SELECT StudentName,Phone,[Address] FROM Student WHERE Phone LIKE '1387%'
--NO.4
SELECT StudentName,StudentNo,[Address] FROM Student WHERE StudentName LIKE '姜_'
--NO.5
SELECT Id,StudentNo,SubjectId,StudentResult,ExamDate FROM Result WHERE StudentNo LIKE 's1101004' AND SubjectId LIKE '[1-3]'
--NO.6
SELECT * FROM Student WHERE BornDate BETWEEN '1989-1-1' AND '1995-12-31'

--上机练习二
--NO.1.
SELECT COUNT(*)FROM Result
--NO.2.
SELECT SUM(ClassHour)FROM Subject
--NO.3
SELECT SUM(StudentResult) AS 学号为s1101004 FROM Result,Grade  WHERE StudentNo='s1101004' AND GradeId=1  
--NO.4
SELECT AVG(StudentResult) AS 学号为s1101004 FROM Result,Grade  WHERE StudentNo='s1101004' AND GradeId=1 
--NO.5
SELECT MAX(StudentResult) AS 最高分,MIN(StudentResult) AS 最低分,AVG(StudentResult) AS 平均分 FROM Result,Subject WHERE ExamDate='2013-3-22'AND SubjectName='使用C#语言开发数据库应用系统'
--NO.6
SELECT AVG(StudentResult) AS 平均分 FROM Result,Subject WHERE StudentResult>60 AND SubjectName='使用C#语言开发数据库应用系统'
--NO.7
SELECT AVG(StudentResult) AS 平均分 FROM Result,Subject WHERE SubjectName='使用C#语言开发数据库应用系统'

第十章 上机 (SQL)

第十章上机 (SQL)