sql querry

Jul 10 2013 1:51 AM

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

Answers (2)

How to session the ID

Join multiple tables