sql without select without duplicate code example

Example: how to query without duplicate rows in sql

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