Scribd
Upload
912 views1 page

SQL Aggregate Functions Guide

This document lists and describes 20 different aggregate functions that can be used to analyze and summarize data from multiple rows in a database table. Some examples of functions listed include MAX(), MIN(), SUM(), AVG(), and COUNT() to find the maximum value, minimum value, total sum, average, and count of rows that meet certain criteria. The document also provides 20 examples of how these aggregate functions could be used with columns in an employee table to calculate values like total salary by department, average salary by job type, and number of employees meeting certain conditions.

Uploaded by

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

SQL Aggregate Functions Guide

This document lists and describes 20 different aggregate functions that can be used to analyze and summarize data from multiple rows in a database table. Some examples of functions listed include MAX(), MIN(), SUM(), AVG(), and COUNT() to find the maximum value, minimum value, total sum, average, and count of rows that meet certain criteria. The document also provides 20 examples of how these aggregate functions could be used with columns in an employee table to calculate values like total salary by department, average salary by job type, and number of employees meeting certain conditions.

Uploaded by

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

MULTI ROW FUNCTIONS/GROUP/AGGRIGATE FUNCTIONS

---------------------------------------------
[Link]( )
[Link]( )
[Link]( )
[Link]( )
[Link]( )

[Link] NUMBER OF EMPLOYEES GETTING SALARY LESS THAN 2000 IN DEPTNO 10


[Link] TOTAL SALARY NEEDED TO PAY EMPLOYEES WORKING AS CLERK
[Link] AVERAGE SALARY NEEDED TO PAY ALL EMPLOYEES
[Link] NUMBER OF EMPLOYEES HAVING 'A' AS THEIR FIRST CHARACTER
[Link] NUMBER OF EMPLOYEES WORKING AS CLERK OR MANAGER
[Link] TOTAL SALARY NEEDED TO PAY EMPLOYEES HIRED IN FEB
[Link] NUMBER OF EMPLOYEES REPORTING TO 7839 (MGR)
[Link] NUMBER OF EMPLOYEES GETTING COMISSION IN DEPTNO 30
[Link] AVG SAL , TOTAL SAL , NUMBER OF EMPS AND MAXIMUM SALARY GIVEN
TO EMPLOYEES WORKING AS PERSIDENT
[Link] NUMBER OF EMPLOYEES HAVING 'A' IN THEIR NAMES
[Link] NUMBER OF EMPS AND TOTAL SALary needed to pay THE EMPLOYEES
WHO HAVE 2 CONSICUTIVE L's IN THEIR NAMES
[Link] NUMBER OF DEPARTMENTS PRESENT IN EMPLOYEE TABLE
[Link] NUMBER OF EMPLOYEES HAVING CHARACTER '_' IN THEIR NAMES
[Link] NUMBER OF EMPLOYEES HAVING ATLEAST 2 PERCENTILES IN THEIR NAMES
[Link] TOTAL SALARY GIVEN TO EMPLOYEES WORKING AS CLERK IN DEPT 30
[Link] MAXIMUM SALARY GIVEN TO THE EMPLOYEES WORKING AS ANALYST
[Link] NUMBER OF DISTINCT SALARIES PRESENT IN EMPLOYEE TABLE
[Link] NUMBER OF JOBS PRESENT IN EMPLOYEE TABLE
[Link] AVG SALARY GIVEN TO THE CLERK
[Link] MINIMUM SALARY GIVEN TO THE EMPLOYEES WHO WORK IN DEPT 10
AS MANAGER OR A CLERK

You might also like