DML-select-Distinct:

qThe DISTINCT clause allows you to remove duplicates from the result set. The DISTINCT clause can only be used with select statements

Syntax:

SELECT DISTINCT column_name(s) FROM table_name

Query:

SELECT DISTINCT Empname FROM EMptbl1