SQL query for duplicate value in one table

jDevon · Dec 15, 2008

I have tried implementing the query to find records in one table that have equal values in one column and for some reason it does not retrieve correct result. I have been using an online SQL interpretor to access a table.Is there something wrong with this statement:

SELECT firstname FROM empinfo GROUP BY age HAVING (COUNT(age) > 1)

Thanks

PHV · Dec 15, 2008

Either:
SELECT A.firstname, A.age
FROM empinfo A INNER JOIN (
SELECT age FROM empinfo GROUP BY age HAVING COUNT(*) > 1
) B ON A.age = B.age

or:
SELECT firstname, age
FROM empinfo
WHERE age IN (SELECT age FROM empinfo GROUP BY age HAVING COUNT(*) > 1)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

alapatis · Apr 23, 2009

SELECT firstname,age FROM empinfo GROUP BY age HAVING (COUNT(age) > 1)

r937 · Apr 24, 2009

alapatis, that statement is invalid

see either of PHV's solutions

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

PHV · Apr 28, 2009

jDevon, did you solve your issue ?

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

SQL query for duplicate value in one table

jDevon

Technical User

PHV

MIS

alapatis

Instructor

r937

Technical User

PHV

MIS

Similar threads

Part and Inventory Search

Sponsor