Write a query to find the name of the employee getting the maximum salary. Assume there are two tables: one with employee ID and name, and another with employee ID, month, and salary.

SQL queries to find the employee with the highest salary from two tables.

• Use UNION to combine results from both tables.

• Select the maximum salary using MAX() function.

• Example: SELECT MAX(salary) FROM (...read more

Select ename,max(sal)

From emp

Group by ename;

Select employee_name, max(salary) as max_salary

From employees;