Some of them which every interviewer will expect: -
• AVG: - Computes the average of a specific set of values, which can be an expression list or a set of data records in a table.
• SUM: - Returns the sum of a specific set of values, which can be an expression list or a set of data records in a table.
• COUNT: - Computes the number of data records in a table.
• MAX: - Returns the maximum value from a specific set of values, which can be an expression list or a set of data records in a table.
• MIN: - Returns the minimum value from a specific set of values, which can be an expression list or a set of data records in a table.
Asked In: Many Interviews |
Alert Moderator