Write a query to get the maximum and minimum salary in the company.

Objective:

Write a SQL query to get the maximum and minimum salary from the employees table.

Assumed Table: employees

SQL Query to Get Max and Min Salary:

SELECT 
    MAX(salary) AS max_salary,
    MIN(salary) AS min_salary
FROM 
    employees;

Explanation:

• MAX(salary) → Finds the highest salary in the salary column.
• MIN(salary) → Finds the lowest salary in the salary column.
• AS → Gives an alias (column name) to the output for better readability.

Output:

Bonus Tip:

If you want to include the employee name along with the max/min salary, you can use subqueries:

Get Employee(s) with Maximum Salary:

SELECT * FROM employees
WHERE salary = (SELECT MAX(salary) FROM employees);

Get Employee(s) with Minimum Salary:

SELECT * FROM employees
WHERE salary = (SELECT MIN(salary) FROM employees);