Viewing 15 posts - 1 through 15 (of 31 total)
thanks sean so much pal .....
May 2, 2011 at 2:53 pm
Department_NoLowest_Avg_Annual_Salary
1908792.307692
May 2, 2011 at 2:50 pm
select top 1 d.Department_No,(AVG(Annual_Salary)) AS Lowest_Avg_Annual_Salary
from Departments d
inner join
Employees e
on d.Department_No=e.Department_No
group by D.Department_No
order by AVG (annual_salary)
hiya, i get it with this query.but what if i had a list of...
May 2, 2011 at 2:49 pm
no good
May 2, 2011 at 2:32 pm
Msg 156, Level 15, State 1, Line 90
Incorrect syntax near the keyword 'top'.
May 2, 2011 at 2:25 pm
select d.Department_No,top 1*(AVG(Annual_Salary)) AS Lowest_Avg_Annual_Salary
from Departments d
inner join
Employees e
on d.Department_No=e.Department_No
group by D.Department_No
order by AVG (annual_salary)
May 2, 2011 at 2:20 pm
ok...sorry...
May 2, 2011 at 2:19 pm
top clause...where does it go and how?lol
May 2, 2011 at 2:13 pm
where annual salary is minimum?
May 2, 2011 at 2:06 pm
select d.Department_No,(AVG(Annual_Salary)) AS Lowest_Avg_Annual_Salary
from Departments d
inner join
Employees e
on d.Department_No=e.Department_No
group by D.Department_No
order by AVG (annual_salary)
Department_NoLowest_Avg_Annual_Salary
1908792.307692
609715.789473
1011180.000000
3013700.000000
8014400.000000
2015233.333333
7018400.000000
11019797.500000
5020746.428571
9081666.666666
May 2, 2011 at 1:58 pm
select d.Department_No,(AVG(Annual_Salary )) AS Lowest_Avg_Annual_Salary
from Departments d
inner join
Employees e
on d.Department_No=e.Department_No
group by d.Department_No,Annual_Salary
May 2, 2011 at 1:52 pm
?..need help
May 2, 2011 at 1:51 pm
LOST
May 2, 2011 at 1:46 pm
where average salary is ==minimum ?..
May 2, 2011 at 1:19 pm
select d.Department_No,(AVG(Annual_Salary)) AS Lowest_Avg_Annual_Salary
from Departments d
inner join
Employees e
on d.Department_No=e.Department_No
group by D.Department_No
Department_NoLowest_Avg_Annual_Salary
1011180.000000
2015233.333333
3013700.000000
5020746.428571
609715.789473
7018400.000000
8014400.000000
9081666.666666
11019797.500000
1908792.307692
May 2, 2011 at 1:15 pm
Viewing 15 posts - 1 through 15 (of 31 total)