This small tips discussed about how to get list of duplicate items for the collection that we do in sql.
For example I have to get list of the email id which is get entered in user table more than one time.
1 2 3 4 5 6 | SELECT email, COUNT(email) AS NumOccurrences FROM users GROUP BY email HAVING ( COUNT(email) > 1 ) |
Linq query work same as on the set of collection and which make use of count
1 2 3 4 5 6 7 | DataClassesDataContext db = new DataClassesDataContext(); var duplicates = db.Users .GroupBy(i => i.emailid) .Where(g => g.Count() > 1) .Select(g => g.emailid); foreach ( var d in duplicates) Console.WriteLine(d); |
So by using above query you can easily achieve task of finding duplicate for your set of collection.
Superb post, wonderful page style, keep up the good work
It is really a great and useful piece of information. I am satisfied that you just shared this helpful information with us. Please stay us up to date like this. Thanks for sharing.