Using Row_Number - SQL Row Iteration to fetch Duplicate record
SQL 2008
How to fetch only list of duplicate memberid rows in a member table ??
Member Table have some duplicate memberid's. This is done on purpose.
Now i need to iterate row by row and fetch all the records which has more than one member id.
How to fetch only list of duplicate memberid rows in a member table ??
Member Table have some duplicate memberid's. This is done on purpose.
Now i need to iterate row by row and fetch all the records which has more than one member id.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.