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

Bookmark It

< Previous : Find and Delete duplicate records in a table

Next > : difference between Early Binding and Late Binding?

Posted by: Natish on: 11/12/2012 | Points: 10

select city ,name from Employee WHERE avg(salary)>2000

More Interview Questions by Kamlesh420

Latest Interview Questions