Aggregate Function in SQL | Sharp Tutorial

SQL

DBMS

Aggregate Functions in sql

An aggregate function is a function where the values of multiple rows are grouped together to give the single output value eg count , max, min , sum etc.

Syntax:

select aggregate function(column name)

from table name

where clause (optional).

SQL Query to count the number of students.

    select count(rollNo) from student ;

SQL Query to find the max fee and minimum fee from student table.

    select max(fee) from student ;

Above query may also be used with min function to find the minimum value. Where clause may also be combined to apply function only on selected records .

    select sum(fee) from student ;

    select avg(fee) from student ;

Python

Java

C

C++

HTML/CSS

Java Script

PHP

SQL

C Programs

Aggregate Functions in sql

SQL Query to count the number of students.

SQL Query to find the max fee and minimum fee from student table.

Video/ C Introduction