Need: Query to show double records 1

[Nage]

Hello,

Does anybody know the query-sting to show all records which have a double product number?

ex.
(product) (prod. number)
Prod 1 AB11
Prod 2 AB12
Prod 3 AB13
Prod 4 AB12
Prod 5 AB13

The query has to show:
Prod 2
Prod 4
Prod 3
Prod 5

Can't find it in the manual!

Please help!

Nage

 

[tlbroadbent]

Write a query that counts the entries per product. Select records from the result that have count=2. Use COUNT function, GROUP BY and HAVING clauses.

Select Product From Table
Where ProdNo In
(Select ProdNo From table
Group By ProdNo Having Count(*)=2)

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.