How to calculate minimum salary, maximum salary, and average salary?

Answer 1

select min(salary) from employee; ---> minimum salary,
select max(salary) from employee; ---> maximum salary,
select avg(salary) from employee;---> average salary
these are the queries, in which employee is table name and salary is column name, using min() , max() , avg () functions you can calculate

Answer 2

select min (salary),max (salary),avg (salary) from employee;

Answer 3

select min(salary), max(salary), avg(salary) from table_name;

Answer 4

yeah that's good

Answer 5

Wow it's working., thanks all of you...

Answer 6

use functions avg(salary) min(salary) and max(salary)