The query finds the employee name who earns the maximum salary.

• Use the SELECT statement to retrieve the employee name and salary from the database table.

• Use the ORDER BY clause to sort the results in ...read more

Select ename,max(sal)

From emp

Group by ename;

Select employee_name, max(salary) as max_salary

From employees;