YogeshChauhan . com

MIN, MAX, COUNT, AVG and SUM in SQL

in SQL/MySQL on August 24, 2019

In this short blog post I am going to discuss about the functions in SQL with examples. Let's start with the MIN and MAX.

  1. MIN(): Returns the smallest value from the selected COLUMN.

Syntax:


SELECT MIN(column_name)
FROM table_name
WHERE condition;

Example:


SELECT MIN(LifeExpectancy) AS LifeExpectancy FROM country;

Returns:
Lowest Life Expectancy
37.2
  1. MAX(): Returns the largest value from the selected COLUMN.

Syntax: 


SELECT MAX(column_name)
FROM table_name
WHERE condition;

Example:


SELECT MAX(LifeExpectancy) AS LifeExpectancy FROM country;

Returns:
Highest Life Expectancy
83.5
  1. COUNT(): Returns the number of rows for the applied condition.

Syntax:


SELECT COUNT(column_name)
FROM table_name
WHERE condition;

Example:


SELECT COUNT(ID) AS ID FROM city;

Returns:
Total Countries
4079
  1. AVG(): Returns the average for a column. The column has to be numeric or it'll show an error.

Syntax:


SELECT AVG(column_name)
FROM table_name
WHERE condition;

Example:


SELECT AVG(Population) AS Population FROM country;

Returns:
Average Population
25434098.1172
  1. SUM(): Returns the sum for a column. The column has to be numeric or it'll show an error.

Syntax:


SELECT SUM(column_name)
FROM table_name
WHERE condition;

Example:


SELECT SUM(Population) AS Population FROM country;

Returns:
Total Population
6078749450

 

amazon

Most Read

#1 How to check if radio button is checked or not using JavaScript? #2 Solution to “TypeError: ‘x’ is not iterable” in Angular 9 #3 How to add Read More Read Less Button using JavaScript? #4 How to uninstall Cocoapods from the Mac OS? #5 How to Use SQL MAX() Function with Dates? #6 PHP Login System using PDO Part 1: Create User Registration Page

Recently Posted

Jun 16 What are Stored Procedures for SQL Server? Jun 16 What are Class Constants in PHP? Jun 15 A short basic guide on states in React Jun 15 How to define constants in PHP? Jun 15 How to define visibility for a property in PHP? Jun 15 How to use @if and @else in SCSS?

You might also like these

CROSS JOIN in PostgresPostgresHow to create a simple slider with CSS and jQuery?CSSHow to define constants in PHP?PHPHow to uninstall Cocoapods from the Mac OS?MiscWhat are “holes” in a React component?ReactWhat is Git?Misc