Advertisement
Guest User

Untitled

a guest
May 28th, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.32 KB | None | 0 0
  1. SELECT COUNT(*) AS [NUMBER OF Employees],
  2.        MIN(Salary) AS [Minimal Salary],
  3.        DepartmentID,
  4.        JobTitle,
  5.        ExampleEmployee = (SELECT TOP 1 FirstName + ' ' + LastName FROM Employees e WHERE e.Salary = MIN(m.Salary) AND e.JobTitle = m.JobTitle)
  6.     FROM Employees m
  7.     GROUP BY DepartmentID, JobTitle
  8. ORDER BY DepartmentID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement