/SQL/How to get non distinct values in sql

How to get non distinct values in sql

SELECT [EmailAddress], [CustomerName] FROM [Customers] WHERE [EmailAddress] IN
  (SELECT [EmailAddress] FROM [Customers] GROUP BY [EmailAddress] HAVING COUNT(*) > 1)

Source: stackoverflow.com

Similar codes

0 vote219 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote197 views2 answers
How to display enum value sql server
SQL
-1 vote205 views1 answer
How to reset autoincrement in sqlite java
SQL
-1 vote144 views1 answer
How to create script to connect to oracle database and run query
SQL
2 votes196 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
0 vote148 views1 answer
Oracle sql developer script output limit
SQL
0 vote245 views1 answer
Datagrip exec
SQL
-1 vote209 views1 answer
Add bool column in sql
SQL
23 votes167 views3 answers
Mysqldump
SQL
0 vote192 views1 answer
Restore backupfile discourse
SQL