If you are asking for three queries....
Select top(1) PersonName from person Order by Salary Desc Select PersonName from person where citycode=12 select PersonName from Person where age=32
if you are asking for name of the person earning highest salary in citycode 12 and age 32. Then the query is:
Select top(1) PersonName from person where citycode=12 and age=32 order by salary Desc
if this is not what u required.. use Improve Question widget....
As per your requirement u can use the multiQuery written by Damian S or
Select p1.PersonName from person p1
inner join (Select Max(salary) as maxsalary from person where Citycode=12 and age=32)p2 on p1.salary=p2.maxsalary Where p1.CityCode=12 and p1.age=32
But if you want max salary grouped on person you can use:
Select PersonName, max(Salary) as Salary from person where age=32 and Citycode=12 Group by PersonName