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

Use configSource attribute to manage Web.Config sections in ASP.Net 2.0

-
Different Sections in Web.Config can be managed by using external XML files, like Connection strings, Appsettings ..... Create a XML file with the respective settings and put that file in App_Data folder to protect <?xml version="1.0" standalone="yes"?> <connectionstrings> <!-- Connection String for SQL Server 2005 Express --> <add name=" SiteSqlServer " connectionstring=" Your Connection " providername=" System.Data.SqlClient " /> <!-- Connection String for SQL Server 2000/2005 <add name=" SiteSqlServer " connectionstring=" Your Connection " providername=" System.Data.SqlClient " /> --> </connectionstrings> Save the file in App_Data folder you need to change the Settings in Web.Config <connectionstrings configsource="App_Data\yourFileName.xml" /> You can manipulate the values by simply changing the respective XML files. No need to change the Web.Co
Read more

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 teams involved in the software development lifecycle. It emphasizes breaking down silos and fostering
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