difference between select distinct id and select distinct * in sql

Question

i tried with

select distinct ID  from  DB.TABLE;

it returned unique ids in all records.

select distinct *  from  DB.TABLE;

it will return unique records by comparing all columns and records or what is functionality of "distinct *" ,i confused with functionality of distinct * .

Answer 1

DISTINCT means that there will be no duplicate rows in the resultset, duplicate meaning all columns have the same value in both rows. So yes, DISTINCT * means "select all columns and skip any rows where the values in all columns match some already included row".