Start by getting your results in order of average salary smallest to largest.

Start by getting your results in order of average salary smallest to largest.

This is where you need to add TOP and order by...

Now you are getting there. Now how can you get the one with the lowest avg?

Forget your assignment for now. Modify your query to get each department and their avg annual salary.

(Hint: Remove the MIN function)

Yes I could create the sql in about 10...

LOL. Can you get a query that gets all departments with their average annual salary? (hint: removed the MIN function). Don't worry about if it is the final answer (it...

Well you are still nesting aggregates which will never work. Logically it just doesnt make sense. Create your query to get the average for all departments, then use TOP and...

Looks like you had a query to get the average monthly salary for each department. Now how do you find the one with the lowest?

As Dave and I both suggested you should use the TOP clause and order by your aggregate.

normanshongo2003 (5/2/2011)

---

Hi folks, im having bother with this sql query...

List the department number and the annual salary of the department with the lowest average annual salary

select d.Department_No,MIN(AVG(Annual_Salary)) AS Lowest_Avg_Annual_Salary

from Departments...

Do you currently have a maintenance plan for regular backups? If so, then just copy the backup to wherever you want it to be. If you don't, you need to.

And what does that have to with sql server???

Didn't really get what you have tried on your own but something like this should get you in the right direction...

select ID, data, (select top 1 VDate from dummy where...

ok so here is what I have for some sample ddl and data...

create table dummy

(

data varchar(25),

VDate varchar(25),

ID int

)

insert dummy select 'xyz', 'Jan 1, 1990', '1'

union all

select 'pdq','','2'

union all

select 'str','','3'

union all

select...

Is there a question here?