Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sarnath1980
Starting Member
1 Post |
 Posted - 2009-08-29 : 04:13:05
|
Can anyone please help me writing the following query:Using self join(Not using correlated sub-query)To find those salary and employee_name from a table where salary of the employees are greater than the average salary of all employees.SARNATH  |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-08-29 : 11:17:27
|
you can use derived table to do it
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
To find salary>avg.salary using join