Loading

sql querry

siddharth rai

13y1.6kSQL

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanjeeb Lenka13y ago
try this

SELECT DISTINCT Name, Salary FROM EMP WHERE
Salary = (SELECT Max(Salary) FROM EMP) And CityCode=12 and Age=32
0
Iftikar Hussain13y ago
Hi,
try like this

select Name,MAX(Salary) from person
where CityCode=12 and Age=32
GROUP BY Name

Regards,
Iftikar
0