exclude duplicates in sql code example

Example 1: how to remove duplicate in sql

Distinct: helps to remove all the duplicate
records when retrieving the records from a table.

SELECT DISTINCT FIRST_NAME FROM VISITORS;

Example 2: sql exclude duplicates and find even id

SELECT DISTINCT city FROM tablename WHERE id % 2 = 0