how to exclude the duplicate number is sql code example

Example 1: how to query without duplicate rows in sql

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

Example 2: sql exclude duplicates and find even id

SELECT DISTINCT city FROM tablename WHERE id % 2 = 0