distinct in mssql code example

Example 1: select count of distinct values sql

SELECT COUNT (DISTINCT column-name)  FROM table-name

Example 2: query DISTINCT

SELECT DISTINCT Column_name FROM table_name;