---
title: "‘SELECT’ command with Aggregate Function"  
description: "SQL provides some aggregate function which is used in database. It is predefined which available by SQL server. SQL aggregate functions return a singl"  
author: "Anonymous User"  
published: 2011-07-08  
updated: 2019-10-11  
canonical: https://www.mindstick.com/articles/558/select-command-with-aggregate-function  
category: "database"  
tags: ["database"]  
reading_time: 2 minutes  

---

# ‘SELECT’ command with Aggregate Function

SELECT command with Aggregate Function:\

SQL provides some aggregate function which is used in database. It is predefined which available by SQL server. SQL aggregate functions return a single value, calculated from values in a column. There are lots of aggregate functions in SQL server in which some are briefly described below:

##### SELECT command with AVG () function:

AVG () function are widely used to calculate the average of column value that is The AVG () function returns the average value of a numeric column.

##### Syntax:

SELECT AVG [SPECIFIED_COLUMN_NAME] FROM <TABLE_NAME>

##### Example:

```
                ---- CALCULATE AVERAGE OF SALARY IN DATABASE TABLE STUDENT_MARKSSELECT AVG(SALARY) AS AVERAGE FROM STUDENT_MARKS
```

![‘SELECT’ command with Aggregate Function](https://www.mindstick.com/mindstickarticle/485e31f2-613e-4758-8d4f-5a5d74c3a2ed/images/4dfc9375-776f-4f02-924d-07e1ba0b0a4a.png)

##### SELECT command with SUM () function:

SUM () aggregate function returns sum of all column value.

##### Syntax:

SELECT SUM ([SPECIFIED_COLUMN_NAME]) FROM <TABLE_NAME>

##### Example:

```
---- CALCULATE SUM OF ALL VALUE SALARY COLUMN SELECT SUM(SALARY) AS SUMSALARY FROM STUDENT_MARKS
```

![‘SELECT’ command with Aggregate Function](https://www.mindstick.com/mindstickarticle/485e31f2-613e-4758-8d4f-5a5d74c3a2ed/images/4059dc8a-d1d9-4d59-9df4-841c703fa632.png)

##### SELECT command with COUNT () function:

Count () aggregate function returns number of rows either specified any column name or whole table.

##### Syntax:

SELECT COUNT ([SPECIFIED_COLUMN_NAME] | [ALL]) FROM <TABLE_NAME>

##### Example:

```
--- COUNT THE NUMBER OF ROWS IN STUDENT_MARKS TABLESELECT COUNT(*) FROM STUDENT_MARKS
```

\

![‘SELECT’ command with Aggregate Function](https://www.mindstick.com/mindstickarticle/485e31f2-613e-4758-8d4f-5a5d74c3a2ed/images/3d4c0cb0-bf45-41dc-81fd-692c5d355a53.png)

##### SELECT command with MAX () function:

Max () function returns maximum value of column.

##### Syntax:

SELECT MAX ([SPECIFIED_COLUMN_NAME]) FROM <TABLE_NAME>

##### Example:

```
--- CALCULATE MAX VALUE OF COLUMN USING MAX FUNCTIONSELECT MAX(SALARY) FROM STUDENT_MARKS
```

\

![‘SELECT’ command with Aggregate Function](https://www.mindstick.com/mindstickarticle/485e31f2-613e-4758-8d4f-5a5d74c3a2ed/images/a87ef553-e4d0-41a8-a608-d1ff1fd2c9ed.png)

##### SELECT command with MIN () function:

MIN () function returns the minimum value of column of table.

##### Syntax:

SELECT MAX ([SPECIFIED_COLUMN_NAME]) FROM <TABLE_NAME>

##### Example:

```
--- CALCULATE MIN VALUE OF COLUMN USING MIN FUNCTIONSELECT MIN(SALARY) FROM STUDENT_MARKS
```

\

![‘SELECT’ command with Aggregate Function](https://www.mindstick.com/mindstickarticle/485e31f2-613e-4758-8d4f-5a5d74c3a2ed/images/dfa8e953-9b90-44be-8867-ccdae866a6be.png)

---

Original Source: https://www.mindstick.com/articles/558/select-command-with-aggregate-function

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