sql unique function code example

Example 1: select count of distinct values sql

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

Example 2: DISTINCT SQL

SELECT DISTINCT column1, column1, ..... FROM TABLE
/*DISTINCT WILL NOT SELECT THE SAME VALUES IN SAME COLUMN*/