Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
You are working with a lakehouse in Fabric that contains a table named 'Employees' with columns 'EmployeeID', 'FirstName', 'LastName', 'Department', and 'Salary'. You need to write a SQL query to find the highest paid employee in each department. How would you structure this query?
You are working with a lakehouse in Fabric that contains a table named 'Employees' with columns 'EmployeeID', 'FirstName', 'LastName', 'Department', and 'Salary'. You need to write a SQL query to find the highest paid employee in each department. How would you structure this query?
Simulated
A
SELECT Department, MAX(Salary) AS HighestSalary FROM Employees GROUP BY Department;
100.0%
B
SELECT Department, Salary AS HighestSalary FROM Employees;
0.0%
Comments
Loading comments...