MySql Subquery

Question

MySql Subquery

Navigation

#1 by (2 votes)
#2 by (1 votes)

1

I have an employee table that has only three columns, NOME , CARGO and SALARIO , I want to set up a query that brings me this whole table and contains the highest salary value for the job. Totalizing 4 Columns ( NOME , CARGO , SALARIO and MAIOR_SALARIO_P_CARGO This is to check the variation.

sql-select

asked by anonymous 15.05.2014 / 16:59

2 answers

Feed hidden field by click on the column of a table Create Array of Objects in java and access objects directly

score 2 · Answer 1

2

SELECT
    T1.NOME,
    T1.CARGO,
    T1.SALARIO_ATUAL,
    (
        SELECT MAX(SALARIO_ATUAL)
        FROM TABELA T2
        WHERE T2.CARGO = T1.CARGO
    ) AS MAIOR_SALARIO_PARA_CARGO
FROM TABELA T1

15.05.2014 / 18:01

score 1 · Answer 2

Answers:

SubQuery

SELECT a.nome, a.cargo, a.salario, (select max(salario) from tbsalarios b where b.cargo = a.cargo) maiorsalario FROM tbsalarios a

JOIN

SELECT a.nome, 
       a.cargo, 
       a.salario, 
       b.maior 
FROM tbsalarios a 
LEFT JOIN 
      (select max(salario) maior, cargo from tbsalarios group by cargo) as b on b.cargo = a.cargo