select distinct count in sql 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*/

Example 3: query DISTINCT

SELECT DISTINCT Column_name FROM table_name;

Example 4: count in sql and diff

select (count(city)-count(distinct city)) from station;