Re: how to select a 'not unique' field?

Mike Krolewski wrote:

> select resultid
> from OBJECT
> group by resultid
> having count(resultid) > 1

I like your SQL better then my suggestion on this one, but compromise for null values though. It is so annoying when a group by function "skips" over your nulls.

select resultid
from OBJECT
group by resultid
having count(nvl(resultid, null)) > 1

Jay!!! Received on Thu Dec 14 2000 - 19:08:43 CST