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

From: Jay Weiland <jay_at_pixar.com>
Date: Thu, 14 Dec 2000 16:54:28 -0800
Message-ID: <3A396BC4.A4CA87A0@pixar.com>

Hey Susana,

     I like inline views for this one...

select nvl(resultid, 'NULL')
from (select resultid, count(*) appearances

      from object
      group by resultid) score

where score.appearances > 1

...it even catches those pesky NULL values when they appear.

Jay!!!

susana73_at_hotmail.com wrote:

> I have a table called OBJECT and with RESULTID column. The RESULTID
> column is not a PK and is not necessarily be unique. How can I SELECT
> all the id that is NOT UNIQUE?
>
> Thanks!
> Susan
>
> Sent via Deja.com
> http://www.deja.com/

--

Received on Thu Dec 14 2000 - 18:54:28 CST