How to Select Every Row Where Column Value is NOT Distinct

by

This is significantly faster than the EXISTS way:

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

More Related Contents:

  1. How to delete 0 values but not blanks from a column in SQL Server 2008 programming?
  2. Efficiently convert rows to columns in sql server
  3. How can I get column names from a table in SQL Server?
  4. Is there a way to access the “previous row” value in a SELECT statement?
  5. What this query does to create comma delimited list SQL Server?
  6. SQL Server – Return value after INSERT
  7. How can I select the first day of a month in SQL?
  8. SQL NVARCHAR and VARCHAR Limits
  9. Select statement to find duplicates on certain fields
  10. T-SQL datetime rounded to nearest minute and nearest hours with using functions
  11. SQL Server : dynamic pivot over 5 columns
  12. How to select the last record of a table in SQL?
  13. Using a Variable in OPENROWSET Query
  14. How to find current transaction level?
  15. How to create table using select query in SQL Server?
  16. Check for file exists or not in sql server?
  17. Group DateTime into 5,15,30 and 60 minute intervals
  18. Is there a SELECT … INTO OUTFILE equivalent in SQL Server Management Studio?
  19. SQL SERVER: Get total days between two dates
  20. Store multiple bit values in a single table column
  21. SQL Server equivalent to MySQL enum data type?
  22. UPDATE and REPLACE part of a string
  23. Improve SQL Server query performance on large tables
  24. Using IF ELSE statement based on Count to execute different Insert statements
  25. How to execute a stored procedure inside a select query
  26. Using CASE Statement inside IN Clause
  27. Single or multiple databases
  28. SQL Unpivot multiple columns Data
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment