RE: Using SQL to check for duplicate records

["Fisher, Don" <Dfisher@xxxxxxxxxxxxxxxxx>]

I don't know if it's more efficient, but try:
SELECT IPROD FROM IIM group by IPROD 
    Having count(*) > 1

That will give you the IPROD values that are duplicated.  If you want the
specific record numbers, you'll have to use the result set to join back to
IIM.  

Hope that helps. 

Donald R. Fisher, III
Project Manager
Roomstore Furniture Company
(804) 784-7600 extension 2124
DFisher@xxxxxxxxxxxxx

<clip>
Is there a more efficient way, using SQL, to check for duplicate records
than the following?
SELECT A.IPROD, RRN(A) FROM IIM A
WHERE A.IPROD IN ( 
  SELECT B.IPROD FROM IIM B 
  GROUP BY B.IPROD 
  HAVING COUNT(*) > 1) 
<clip>