Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Exclude duplicates from count(*)

Re: Exclude duplicates from count(*)

From: Philippe <parnaud_at_yahoo.com>
Date: Wed, 28 Jul 1999 09:27:59 +0200
Message-ID: <7nmbeh$p8$1@concorde.ctp.com> 





Take a look at COUNT(DISTINCT ColumnName)



HTH,



Philippe



john bruin wrote in message <379E830B.7753_at_tssc.co.nz>...


>Does anyone know if it is possible to perform the


>


> " select count(*) "


>


>statement and somehow exclude duplicate data? I am doing a count from


>the results of joining 2  tables and occasionally some of the data is


>duplicated. Any help appreciated.


>


>Thanks


>John Bruin




Received on Wed Jul 28 1999 - 02:27:59 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US