Scribd
Upload
2 views3 pages

Day - 20 - SQL - Functions in SQL

The document outlines various functions in SQL, categorized into aggregate, string, date and time, mathematical, conditional, and window/analytical functions. It provides examples and descriptions of aggregate functions, including COUNT(), SUM(), AVG(), MAX(), and MIN(), detailing their usage and expected results. The content is part of a course created by Satish Dhawale.

Uploaded by

gigacodingtech0249
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views3 pages

Day - 20 - SQL - Functions in SQL

The document outlines various functions in SQL, categorized into aggregate, string, date and time, mathematical, conditional, and window/analytical functions. It provides examples and descriptions of aggregate functions, including COUNT(), SUM(), AVG(), MAX(), and MIN(), detailing their usage and expected results. The content is part of a course created by Satish Dhawale.

Uploaded by

gigacodingtech0249
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Day – 20 :

Functions in SQL

Course created by Satish Dhawale | [Link]


List of Functions in SQL

Aggregate Functions

String Functions

Date and Time Functions

Mathematical Functions

Conditional Functions

Window/Analytical Functions
Aggregate functions perform calculations on a set of values and
return a single value.

Function Description Example Result


Returns the number of SELECT COUNT(*) FROM
COUNT() Total number of rows
rows employees;
Returns the sum of a SELECT SUM(salary) Total salary of all
SUM()
column FROM employees; employees
Returns the average SELECT AVG(salary)
AVG() Average salary
value FROM employees;
Returns the maximum SELECT MAX(salary)
MAX() Highest salary
value FROM employees;
Returns the minimum SELECT MIN(salary)
MIN() Lowest salary
value FROM employees;

You might also like