title: How to retrieve name of employee having salary greater than the average salary of their respective department
body: <p>I have a table  named "tblEmployee". Columns in this table are "EmpId","Department","Salary".
  Rows in this table are as follows(e1,sales,10000),(e2,hr,20000),(e3,sales,30000),(e4,production,40000),(e5,hr,50000).
  I want to retrieve name of the employee whose salary is greater than the average salary of their  respective department.I want solution for sql server.</p>
  
  <p>Thanks in advance.</p>