just tryin it here dave..lol

lost:ermm:

lost:ermm:

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

from Departments d

inner join

Employees e

on d.Department_No=e.Department_No

order by Annual_Salary

would i just say TOP 1?..

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

sean its just example questions for an exam that im getting next month..

how do i do that dave?..im just beginning sql dave

Column 'Departments.Department_Name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

thx so much that worked gila...it ows doing my head in there for ages...lol...thx again pal...:-)

select sum(annual_salary) as 'total'

from dbo.Employees

where Department_No='80'

this displays the total annual salary for department but to 2 decimal places...i just need 0 decimal places

This code gets me 2 decimal places ..

select SUM(annual_salary) as 'Total'

from dbo.Employees

where Department_No='80'

this code gets me 0 decimal places with monthly salary

select department_no,cast (Annual_Salary/12 as decimal (8,0))as 'Monthly Salary...

select last_name,department_no, (Annual_Salary/12) as 'Monthly Salary'

from Employees

where Department_No='90'

this will show the monthly salary but when i put in ,2 it wont do two decimal places?

ive used the round function but...

it wont work still sorry?

cant get it at all?

sorry its : decimal (8,2)null.....