List:General Discussion« Previous MessageNext Message »
From:jkraai Date:March 30 1999 3:58am
Subject:Re: OT: SQL question
View as plain text  
Quinn Coldiron wrote:
> 
> 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,

select count(part_number) as k, *
from table
group by part_number
having k>1
Thread
OT: SQL questionQuinn Coldiron30 Mar
  • Re: OT: SQL questionjkraai30 Mar