Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT(*) AS [NUMBER OF Employees],
- MIN(Salary) AS [Minimal Salary],
- DepartmentID,
- JobTitle,
- ExampleEmployee = (SELECT TOP 1 FirstName + ' ' + LastName FROM Employees e WHERE e.Salary = MIN(m.Salary) AND e.JobTitle = m.JobTitle)
- FROM Employees m
- GROUP BY DepartmentID, JobTitle
- ORDER BY DepartmentID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement