Re: how to select a 'not unique' field?
From: Jay Weiland <jay_at_pixar.com>
Date: Thu, 14 Dec 2000 17:08:43 -0800
Message-ID: <3A396F1B.1E60FD88_at_pixar.com>
Date: Thu, 14 Dec 2000 17:08:43 -0800
Message-ID: <3A396F1B.1E60FD88_at_pixar.com>
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
[Quoted] having count(nvl(resultid, null)) > 1
Jay!!! Received on Fri Dec 15 2000 - 02:08:43 CET