Subject | Recursive query.... |
---|---|
Author | adrian_avila_mtz |
Post date | 2004-10-27T16:23:05Z |
I need a query that returns only the records than are repeated in the
table
example:
Key Name
----------------
1 John
2 Peter
3 John
4 Jason
5 Peter
6 Robert
7 Laura
8 Jenny
9 Adrian
So, the query would return only this records:
Key Name
----------------
1 John
3 John
2 Peter
5 Peter
What sentence can I use for it?
Thx.
table
example:
Key Name
----------------
1 John
2 Peter
3 John
4 Jason
5 Peter
6 Robert
7 Laura
8 Jenny
9 Adrian
So, the query would return only this records:
Key Name
----------------
1 John
3 John
2 Peter
5 Peter
What sentence can I use for it?
Thx.