Fortune Telling Collection - Comprehensive fortune-telling - Difference between average value and average value in vfp

Difference between average value and average value in vfp

Average is a function used in VF, which is used for vertical average in a table, such as the average score of all students in a class:

Use the report form

Average language &; Seek the average grade of Chinese in the whole class

Average mathematics &; & Seek the average math score of the whole class.

Avg is a function used for vertical averaging in SQL statements, such as:

Sele avg (Chinese) is used as the language average in the report card.

Select avg (Mathematics) from the report as the average score of mathematics.

These two commands are used in different environments, one in VF and the other in SQL query statements.