Re: Count of distinct records
From: Roger Stapley <rstapley_at_uk.oracle.com>
Date: Thu, 09 Dec 1999 15:38:51 +0000
Message-ID: <384FCD0B.4BD4C439_at_uk.oracle.com>
Date: Thu, 09 Dec 1999 15:38:51 +0000
Message-ID: <384FCD0B.4BD4C439_at_uk.oracle.com>
select count(distinct NVL(column1,'NULL')||NVL(column2,'NULL')||...) from table
HTH
Pete Kolton wrote:
>
> We have a table which contains duplicate records.
>
> Obviously we can do a select count(*)... of the records in the table, and we
> can do a select distinct *... of the records in the table.
>
> What we want to do is combine these two so that we get a count of the
> distinct records.
>
> Any suggestions?
Received on Thu Dec 09 1999 - 16:38:51 CET