People, I want to know how to list only the function that has the highest salary and not the highest salaries of all functions, does anyone give me a light? Here's how I'm doing:
select max(Salario) from Funcionarios group by Funcao;
I also did this:
select max(Salario) from Funcionarios;
And that's the way I want it. I want to display the highest salary among all the functions and also the name of this function that has the highest salary, but I do not know how to do it.