PL/SQL Queries

Hi

I am having a little trouble with a couple of queries.

I need to display employee name and department of all employees who are lowest paid in each department, which has 2 or more employees. Salaries have to be assumed to be null. The output is to be ordered by ename within department number.

This is how I have formulated the query to be:

Select ename,
deptno,
sal
count(e.empno)
From emp e,
dept d,
salgrade s
Where ((e.sal between losal and hisal) or
(e.sal is null))
And e.deptno (+) = d.deptno
Having count(e.empno) > 2
Order by ename, deptno

But it is displaying 'no rows selected' - can you tell me where I have gone wrong?

I also need to display the dpartment number and location and the number of clerks in each department within the database.

This is what I have done the query as:

Select loc,
deptno
count(job) "No of Clerks"
From emp e,
dept d
And e.deptno(+) = d.deptno
And job = Clerk
Group by d.deptno, loc

However, it is coming up with an error message that 'e.empno' - any ideas of how I can rectify this?

Cheers

Av.

I think you have some problems with the sql syntax.
For starters:

And e.deptno(+) = d.deptno <--- not a valid sql statement

perhaps you meant:
And e.deptno = d.deptno

???
fv

@fractalvibes

Dude i think you misunderstood...... the syntax is correct.....
if u add (+) symbol in a query it's called outer join...... check it out again......... The use of (+) symbol is absolutely valid.......

maybe in oracle, yeah (although you should be using JOIN syntax instead)

however, this is the db2 forum