How to do a case sensitive GROUP BY?

by

You need to cast the text as binary (or use a case-sensitive collation).

With temp as
(
  select 'Test' as name
  UNION ALL
  select 'TEST'
  UNION ALL
  select 'test'
  UNION ALL
  select 'tester'
  UNION ALL
  select 'tester'
)
Select Name, COUNT(name)
From temp
Group By Name, Cast(name As varbinary(100))

Using a collation:

Select Name Collate SQL_Latin1_General_CP1_CS_AS, COUNT(name)
From temp
Group By Name Collate SQL_Latin1_General_CP1_CS_AS

More Related Contents:

  1. GROUP BY to combine/concat a column [duplicate]
  2. sql group by only rows which are in sequence
  3. I dont know sql syntax for my table [closed]
  4. CROSS JOIN vs INNER JOIN in SQL
  5. How to cast the DateTime to Time
  6. How can I schedule a job to run a SQL query daily?
  7. Reset identity seed after deleting records in SQL Server
  8. How to avoid the “divide by zero” error in SQL?
  9. Multiple INSERT statements vs. single INSERT with multiple VALUES
  10. Real life example, when to use OUTER / CROSS APPLY in SQL
  11. Concat groups in SQL Server [duplicate]
  12. How to update Identity Column in SQL Server?
  13. Common Table Expression, why semicolon?
  14. T-SQL split string based on delimiter
  15. SQL Server 2008: how do I grant privileges to a username?
  16. How do I find duplicates across multiple columns?
  17. Detect consecutive dates ranges using SQL
  18. How to do an inner join on row number in sql server
  19. Stored procedure that exports data into csv files only exports to one file
  20. sql varchar(max) vs varchar(fix)
  21. How do I prevent a database trigger from recursing?
  22. SQL Server: should I use information_schema tables over sys tables?
  23. store arabic in SQL database
  24. Convert Date format into DD/MMM/YYYY format in SQL Server
  25. Converting Select results into Insert script – SQL Server
  26. How to combine results of two queries into a single dataset
  27. Executing SQL Server Agent Job from a stored procedure and returning job result
  28. Cumulative Total in MS Sql server [duplicate]
  29. How do I find the data directory for a SQL Server instance?
  30. Safest way to get last record ID from a table

Leave a Comment