Ask Question

What are aggregate and scalar functions?

Anonymous User
05-Jul-2019
430
1 Answers

Last updated:9/21/2020 2:45:42 AM

MSSQL Server

SQL Server SQL SQL Server 2008 SQL Server 2012

1 Answers

Anonymous User

05-Jul-2019

The aggregate functions are used to evaluate mathematical calculation and return single values. It can be calculated from the columns in a table. Scalar functions return a single value based on the input value.

Example -.

Aggregate – max(), count - Calculated with respect to numeric.

Scalar – UCASE(), NOW() – Calculated with respect to strings.

report abuse

What are aggregate and scalar functions?

1 Answers

Anonymous User

Answer

Login