In this sample dataset the columns are labelled Name, Marks, and Grades. For the grades, we have 5 possible options. Method 1 – Computing Grades in Excel Using the IF Function The IF function in Excel performs
AVG(Grade)AS 'Average Grade' FROM Grades GROUP BY GradeType ORDER BY GradeType 1. 2. 3. 4. 5. 6. 感觉像 EXCEL 中的分类汇总功能。 如果想把 Grade 为 NULL 值的当做 0,那么可以用: SELECT GradeType AS 'Grade Type', AVG(ISNULL(Grade,0))AS 'Average Grade' FROM Grades GROUP BY Grade...
we're not talking about updating the display of a few lines in an Excel spreadsheet. Thus, it depends upon the application and for the use we're discussing I'd suggest that it can require quite a bit