Re: Return at least some info

Jane O wrote:

> Using EMP as example with ONE EXTRA column - COMPANY - that has the SAME
> value
> "MSOFT"
> EMPNO NUMBER(4)
> ENAME VARCHAR2(10) Y
> JOB VARCHAR2(9) Y
> MGR NUMBER(4) Y
> HIREDATE DATE Y
> SAL NUMBER(7,2) Y
> COMM NUMBER(7,2) Y
> DEPTNO NUMBER(2) Y
> COMPANY VARCHAR2(10) Y
>
> How can I return this:
>
> COMPANY COUNT(*)
> ---------- ----------
> MSOFT 0
>
> with a query like :
>
> SQL> select max(company), count(*) from emp where job = 'ACTOR' ;
> ...when there is NO such job as "ACTOR" ?
> Thanks

I would like to say that after reading your example twice I understand what you are trying to do ... but I don't. If no one else provides an answer that works perhaps you could repost your request and example being far clearer about what you are trying to do.

But please do so in only one usenet group.

Daniel Morgan Received on Thu Dec 19 2002 - 11:37:44 CST