How can you eliminate duplicate records in a table with select query?

Q. How can you eliminate duplicate records in a table with select query?

Answer =

The DISTINCT clause is used with SELECT statement to hide duplicate records in a table.
For example, to display cities from table suppliers.

SELECT DISTINCT city FROM suppliers;