how to select only not duplicate records in sql code example

Example: how to query without duplicate rows in sql

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