Subject | finding triple entries |
---|---|
Author | Christian Waldmann |
Post date | 2010-09-10T10:10:35Z |
Hello SQL experts
I have a table with a colum visitId ( and some other culoms)
Each visitiId is exactly twice in the tabel. By error there are some
visitId more than twice in the table.
Who knows an efficent query to find all rows where the visitid is
present more than two times?
many thanks
Christian
I have a table with a colum visitId ( and some other culoms)
Each visitiId is exactly twice in the tabel. By error there are some
visitId more than twice in the table.
Who knows an efficent query to find all rows where the visitid is
present more than two times?
many thanks
Christian