Write a sql query which will give result of the city name of the employee whose avg salary > 2000

 Posted by Kamlesh420 on 12/14/2011 | Category: Sql Server Interview questions | Views: 4293 | Points: 40
Answer:

select cityname, avg(salary) as avgsal from Employee   group by cityname  having  avg(salary) >2000


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Natish on: 11/12/2012 | Points: 10
select city ,name from Employee WHERE avg(salary)>2000

Login to post response