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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-24 : 09:22:57
|
firoz writes "My Question->Find employee who earn a salary greater than the average salary for their department. Table is as follows-ENAME JOB HIREDATE SAL DEPTNO---------- --------- --------- ---------- ----------SMITH CLERK 17-DEC-80 800 20ALLEN SALESMAN 20-FEB-81 1600 30WARD SALESMAN 22-FEB-81 1250 30JONES MANAGER 02-APR-81 2975 20MARTIN SALESMAN 28-SEP-81 1250 30BLAKE MANAGER 01-MAY-81 2850 30CLARK MANAGER 09-JUN-81 2450 10SCOTT ANALYST 09-DEC-82 3000 20KING PRESIDENT 17-NOV-81 5000 10TURNER SALESMAN 08-SEP-81 1500 30ADAMS CLERK 12-JAN-83 1100 20JAMES CLERK 03-DEC-81 950 30FORD ANALYST 03-DEC-81 3000 20MILLER CLERK 23-JAN-82 1300 10" |
|
|
|
|
|
reteiving conditional records