Select distinct rows from a table

In a table, a column may contain many duplicate values; and sometimes you only need to list the distinct rows or values.

The DISTINCT keyword can be used to return only distinct (different) values.

SQL SELECT DISTINCT Syntax

SELECT DISTINCT column_name,column_name
FROM table_name;

select distinct name,salary, country from tblemployee;

select distinct * from tblemployee;