If a table contains duplicate rows, does a query result display the duplicate values by default? How can you eliminate duplicate rows from a query result code example

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