Duplicate Column values in a SQL Table

-
How to Get Values of column having duplicate records in some other column.

Scenario

I have a table having multiple columns, the two named are ID and email, Now i what i want to do is that i want the values of ID's for those Columns having same email address or duplicate email address. Suppose we have the following table named "Table1" having two fields ID and Email and having following Data.



IDEmail
1Email1@Email.com
2Email1@Email-2.com
3Email1@Email.com
4Email1HK@Email.com
5Email1@Email.com
6Email1HK@Email.com
7Email1@Email.com
8Email1we@Email.net
9Email1sd@Emailz.com
10Email1@Email.com
11Email1n@Email.com
12Email1@Email.com


Use the following SQL Query to get ID's having Duplicate Email address

Select ID from Table1 where Name IN (SELECT Name FROM Table1 GROUP BY Name HAVING ( COUNT(Name) > 1 ))

Now this Query will return 1,3,5,7,10,12,4 and 6 from the above table having same Data.

Comments

Post a Comment

Popular posts from this blog

DevOps - Key Concepts - Roles & Responsibilities - Tools & Technologies

-
KEY CONCEPTS FUNDAMENTAL PRINCIPLES  ROLES & RESPONSIBILITIES  TOOLS & TECHNOLOGIES  VERSION CONTROL SYSTEMS (VCS) CONTINUOUS INTEGRATION AND CONTINUOUS DELIVERY (CI/CD)  CONFIGURATION MANAGEMENT  CONTAINERIZATION AND ORCHESTRATION  INFRASTRUCTURE AS CODE (IAC)  MONITORING AND LOGGING TOOLS  COLLABORATION AND COMMUNICATION TOOLS  TEST AUTOMATION TOOLS  CLOUD PLATFORMS AND SERVICES  DevOps  DevOps, short for Development and Operations, is a set of practices and principles that aims to foster collaboration, communication, and integration between development teams and operations teams. It focuses on improving the efficiency, speed, and quality of software development and delivery processes. Key Concepts Here are some key aspects of DevOps: ·          Culture: DevOps promotes a culture of collaboration, trust, and shared responsibility among development, operations, and other tea...
Read more

Rewriting the DotNetNuke Url Rewriter Module

-
Ref: http://www.ifinity.com.au/Blog/Technical_Blog/EntryID/19/ As part of my ongoing interest in making DotNetNuke websites more person and search engine friendly, I started hunting around in the space again to see what was available. While the latest DotNetNuke releases have good ability to enter site rewrite rules (such as an automatic home.aspx redirection), the crucial problem for me is that the site doesn't generate simple Url's (instead it still outputs pagename/tabid/nn/default.aspx) I had previously looked at the Inventua Http module, and while it is a good product, it didn't quite suit my needs. I guess it came down to not being able to get the source code either. It also didn't work with the Catalook module, which I have done some work with and still support on some sites. Further searching brought me across Scott McCulloch's 'Friendly Urls' work on his site at http://www.ventrian.com/Resources/Projects/FriendlyUrls.aspx . (it's even a...
Read more

Trouble In the House of Google

-
Image
Let's look at where stackoverflow.com traffic came from for the year of 2010. When 88.2% of all traffic for your website comes from a single source , criticizing that single source feels … risky. And perhaps a bit churlish, like looking a gift horse in the mouth, or saying something derogatory in public about your Valued Business Partnertm. Still, looking at the statistics, it's hard to avoid the obvious conclusion. I've been told many times that Google isn't a monopoly, but they apparently play one on the internet. You are perfectly free to switch to whichever non-viable alternative web search engine you want at any time. Just breathe in that sweet freedom, folks. Sarcasm aside, I greatly admire Google. My goal is not to be acquired, because I'm in this thing for the long haul – but if I had to pick a company to be acquired by, it would probably be Google. I feel their emphasis on the information graph over the social graph aligns more closely with our mission th...
Read more