select distinct value with all column

Hi Distinct will not work with "*", becuase * means select all the column from table along with joins table column and if you have any modified date or any auditing column it will select those columns also, please check your script instead of using *, use only those column which is required.