From: Quinn Coldiron
Date: March 30 1999 3:56am
Subject: OT: SQL question
List-Archive: http://lists.mysql.com/mysql/1170
Message-Id: <19990330035644.17970.rocketmail@web114.yahoomail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

Can anybody give me some pointers on building an SQL statement to select
all records that duplicates of a certain field?

I have a table holding descriptions and prices of tools, and have
duplicate entries for some part numbers.  I want to get a report of all
those parts that have duplicate entries.

Quinn


===
-------------------------------------------
     ~	   Quinn P. Coldiron
    . .	   Deal Lab, University of Nebraska
    /V\	   http://deal.unl.edu/quinn/
   // \\   qcoldiron@stripped
  /(   )\
   ^`~'^
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com