select distinct sql and count code example

Example 1: select count of distinct values sql

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

Example 2: sql distinct

#List unique values in the df['name'] column
df.name.unique()