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: Query to find non-unique records

Re: Query to find non-unique records

From: Phineas T. Barnham <PhineasTBarnham_at_PhineasTBarnham.com>
Date: Wed, 25 Apr 2001 22:24:16 +0100
Message-ID: <988234183.4510.0.nnrp-12.9e985e86@news.demon.co.uk> 






"Phineas T. Barnham" <PhineasTBarnham_at_PhineasTBarnham.com> > select
id,tag1,tag2


> from my_table

> group by id,tag1,tag2

> having count(*) > 1

>

>



...or, of course, you can use the exceptions clause of alter table...add
constraint.



See manual.
Received on Wed Apr 25 2001 - 16:24:16 CDT












Original text of this message













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