Answers for "aggregate functions in sql example"

aggregate function in sql

-- Emp_Id is a Column Name
 -- employee_tble is Table Name;
 
select count(Emp_Id) from employee_tbl;

select min(Salary) from employee_tbl;

select max(Salary) from employee_tbl;

select sum(Salary) from employee_tbl;

select avg(Salary) from employee_tbl;

aggregate function in sql

--- GROUP FUNCTION | MULTI ROW FUNCTION | AGGREGATE FUNCTION 
--- COUNT , MAX , MIN , SUM , AVG