Re: Check For Uniqueness

Here is some simple SQL that can be used to check duplicates -- it would be easy to modify this to see if a record is unique.

To check for single column duplicates (deptno only):

  select rowid, deptno
  from dept outer
  where
  outer.rowid >
  (select min(rowid) from dept inner
  where inner.deptno=outer.deptno)
  order by deptno;

To check for multi-column (key) duplicates (deptno and dname):

  select rowid, deptno, dname
  from dept outer
  where
  outer.rowid >
  (select min(rowid) from dept inner
  where inner.deptno||inner.dname=outer.deptno||outer.deptno)   order by deptno;
>

--
-cheers
  DW
--------------------------------------------------------------------
"It is a kind of good deed to say well; and yet words are not deeds.
  -William Shakespeare"


Sent via Deja.com http://www.deja.com/
Before you buy.