A table could hold duplicate rows. In such a case, to view only unique rows the distinct clause can be used. The DISTINCT clause allows removing duplicates from the result set. The DISTINCT clause can only be used with select statements.
SELECT DISTINCT ColumnName1,ColumnName2 from TableNam SELECT DISTINCT * from TableName;
