---
title: "What are aggregate and scalar functions?"  
description: "What are aggregate and scalar functions?"  
author: "Anonymous User"  
published: 2019-07-05  
updated: 2020-09-21  
canonical: https://www.mindstick.com/interview/23537/what-are-aggregate-and-scalar-functions  
category: "mssql server"  
tags: ["sql server", "sql", "sql server 2008", "sql server 2012"]  
reading_time: 1 minute  

---

# What are aggregate and scalar functions?

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.
```

## Answers

### Answer by Anonymous User

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.
```


---

Original Source: https://www.mindstick.com/interview/23537/what-are-aggregate-and-scalar-functions

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.