SQL Query to find Max Salary from each department
Exercise
Correct!
SELECT code_here FROM EmpDetails code_here
SELECT DeptID, MAX(Salary) FROM EmpDetails GROUP BY DeptID
assert(line0 == l0);
function rpls(str){
return str.toLowerCase().replace(/'/g,'').replace(/ /g, '');
}
var l0 = rpls("SELECT DeptID, MAX(Salary) FROM EmpDetails GROUP BY DeptID");