sql select non repeated values code example

Example 1: select count of distinct values sql

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

Example 2: how to query without duplicate rows in sql

SELECT DISTINCT col1,col2... FROM table_name where Condition;