Write a sql query which will give result of the city name of the employee whose avg salary > 2000 Published by chandrasekhar - On 6:04 PM // This post haved 0 comments //

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

Asked in many Interview questions,Many Interviews