聚合函数

--查询的是有多少条的数据select COUNT(*) from student--Maxselect * from TblScore--查询的是最高的数学成绩select MAX(TSMath) from TblScore--数学成绩最高的这个人的英语成绩和数学最高成绩select MAX(tsmath),TSEnglish from TblScore--select top 1 tsenglish,TSMath from TblScore order by TSMath desc--成绩表中数学成绩最低的是多少select MIN(TSEnglish) from TblScoreselect SUM(tsenglish) from TblScoreselect AVG(tsenglish) from TblScore--NULL是否参与运算select * from TblScoreselect MAX(tsenglish)as 英语最高成绩,MIN(tsenglish)as最低成绩,SUM(tsenglish) as 总和,AVG(tsenglish) as 平均成绩 from TblScore--统计行的时候null也没参与select COUNT(TSEnglish) from TblScore--数学 最大值 最小值  平均值   总和   有多少条数据  ---合并到一起显示关于*和所有列 换行  null是否 包含在*的问题select * from TblScoreselect tsid,tsenglish,tsmath from TblScoreselect COUNT(TSEnglish) from TblScore