how to get the unique record with condition from a column in sql code example

SELECT DISTINCT column1, column2, ...

 FROM table_name;