sql server - SQL query to determine that values in a column are unique

Question

How to write a query to just determine that the values in a column are unique?

question from:https://stackoverflow.com/questions/26199765/sql-query-to-determine-that-values-in-a-column-are-unique

Answer 1

Try this:

SELECT CASE WHEN count(distinct col1)= count(col1)
THEN 'column values are unique' ELSE 'column values are NOT unique' END
FROM tbl_name;

Note: This only works if 'col1' does not have the data type 'ntext' or 'text'. If you have one of these data types, use 'distinct CAST(col1 AS nvarchar(4000))' (or similar) instead of 'distinct col1'.