Yogesh Chauhan's Blog

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

 


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 PHP Login System using PDO Part 1: Create User Registration Page #6 How to Use SQL MAX() Function with Dates?

Recently Posted

#Aug 15 Is PHP still good for back-end programming? #Aug 10 How to create a multisite network in WordPress? #Aug 3 How to create a circle that follows a cursor using JavaScript and CSS? #Aug 3 How to make a curtain slider using jQuery and CSS? #Aug 2 How to progressively load images and add a blurry placeholder? #Aug 1 How to create a placeholder loader (throbber) using CSS?
You might also like these
The SQL EXISTS OperatorSQL/MySQLGap in Flex?CSSKilling A Project Part 1: What criteria should be used to cancel/kill a project?MiscellaneousHow to create bouncing balls using HTML canvas and JavaScript?HTMLHow to add AppRoutingModule in Angular application using command line?Angular3 Types of Arrays in PHPPHP