Re: OT: SQL question

[jkraai]

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