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

Home -> Community -> Usenet -> c.d.o.server -> Re: Finding rows with column1+column2 values are unique

Re: Finding rows with column1+column2 values are unique

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Fri, 19 Jan 2007 02:59:23 GMT
Message-ID: <Xns98BCC12BE719Canacedenthotmailcom@69.28.173.184>


qazmlp1209_at_rediffmail.com wrote in news:1169013118.142066.56500@ 11g2000cwr.googlegroups.com:

> How do we find out the number of rows in a Table where the combination
> of two (non-key)column values are unique?
>

select col1, col2, count(*)
from mytable
group by col1, col2
having count(*) = 1 Received on Thu Jan 18 2007 - 20:59:23 CST

Original text of this message

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