obtain dublicates from a table 1

[MrDontKnowNothing]

hi again,

a question of interrest and frequent use:

asume you got a table called costumer with columns id, name, email.

you know there are some costumers in the db with the same name and email, but different id:

---id---|---name---|---email---
1 john j@b.com
2 john j@b.com
3 alex a@c.com
4 frank f@v.com
5 tim t@t.com
6 frank f@v.com


how do you get all the dublicates, but only the dublicates?

a result should look like:

---id---|---name---|---email---
1 john j@b.com
2 john j@b.com
4 frank f@v.com
6 frank f@v.com

many thanks for your time!

alex

 

[Mike Gagnon]

Have a look at BPeisch's suggestion in thread184-751089

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[ramani]

HI

If you are cheking for name duplication..

SELECT * FROM myTable WHERE name IN ;
(SELECT name FROM myTable ;
HAVING COUNT(*) > 1 GROUP BY name)




____________________________________________
ramani - (Subramanian.G)

http://winnersoft.coolfreepages.com/