sql querry

Question

I a table person and need a query for those personName who's 1.salary is maximum 2.cityCode is 12 3. age is 32 suppose- there are 3 person with name RAM . AND 3 with name sunil and 3 person with name rahul.... and i need the only those record who contain the maximum salary means ram with maximum salary  sunil with maximum salary and rahul with maximum salary

Sanjeeb Lenka · Answer

try this SELECT DISTINCT Name Salary FROM EMP WHERE Salary = (SELECT Max(Salary) FROM EMP) And CityCode=12 and Age=32

Iftikar Hussain · Answer

Hi try like this select NameMAX(Salary) from person where CityCode=12 and Age=32 GROUP BY Name Regards Iftikar