I try to get a list of distinct name from the query below:
Select distinct [rodnee_WISDAssetsInvRemedy].[CI_NAME], ROW_NUMBER() OVER ( Order By [rodnee_WISDAssetsInvRemedy].[CI_NAME] Asc ) as 'RowNum'
but it only gave me duplicated names.
Very appreciated for your help!!!