SQLServer数据库应用第四章节.pptVIP

SQL Server-chap5--数据检索 本章主要内容 SELECT语句 带条件的查询 多表查询 UNION查询 子查询 Use My_DB1 SELECT year,total= sum(comp_score ) ? FROM stud_score ? GROUP BY(year) ? HAVING year1998 请与WHERE子句对照 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 例：查询学年年度在1996与1998年之间(含1996和1998年)的年度comp_score的总和 USE My_DB1 SELECT year,total= sum(comp_score) ? FROM stud_score ? GROUP BY(year) ? HAVING year BETWEEN 1996 AND 1998 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 4.2.4 COMPUT