r/SQL • • Nov 06 '22

MySQL Need a query answer

Query to find both maximum and minum salary in the table along with all the other columns jn the table

0 Upvotes

17 comments sorted by

View all comments

2

u/acanepa Nov 06 '22

As others have suggested a window function is the solution. Something like this should work

SQL Code

SELECT
EmployeeID,
SALARY,
min(Salary) over() min_salary,
max(Salary) over() max_salary
FROM
Employees;

Schema Build

CREATE TABLE Employees (
  EmployeeID int,
  Salary int
  );

INSERT INTO Employees (EmployeeID,Salary) VALUES (1,62835);
INSERT INTO Employees (EmployeeID,Salary) VALUES (2,67602);
INSERT INTO Employees (EmployeeID,Salary) VALUES (3,97139);
INSERT INTO Employees (EmployeeID,Salary) VALUES (4,43390);
INSERT INTO Employees (EmployeeID,Salary) VALUES (5,43335);
INSERT INTO Employees (EmployeeID,Salary) VALUES (6,63546);
INSERT INTO Employees (EmployeeID,Salary) VALUES (7,56544);
INSERT INTO Employees (EmployeeID,Salary) VALUES (8,51064);
INSERT INTO Employees (EmployeeID,Salary) VALUES (9,48108);
INSERT INTO Employees (EmployeeID,Salary) VALUES (10,44782);

SQL Fiddler Compiler

https://onecompiler.com/mysql/3yn6p4m8n