Motta,
Thanks for the agility, but this instruction is appearing only the highest salary. I tried INNER JOINT, and I almost did it. Imagine that I want to compare the salary of people with the same job. See if you can understand with the attached image.
Friends,
I would like your help in MySql, I have a table of employees that has only three columns, NAME, POST and SALARY, I want to set up a query that brings me this whole table and contains the highest salary value for the position. Totalizing 4 Columns (NAME, CHARGE, SALARY AND MAIOR_SALARIO_P_CARGO This is to check the variation.