Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: URGENT: sql group by clause has stopped working
roobaron wrote:
> try
>
> select owner
> from smith
> where job = 'comp'
> and branch = '9'
> group by owner
> having count(owner) > 1;
>
> The HAVING clause is useful in determining dupes.
>
> Have Fun
>
> --
>
> Posted via dBforums\nhttp://dbforums.com
Your SQL statement is meaningless. You have nothing in the SELECT clause that requires grouping.
The original query, as posted, never worked.
Daniel Morgan Received on Fri Aug 09 2002 - 10:29:35 CDT