在SQL中选择多列时如何使用distinct

I have use simple inner join statement and getting result into CTE table. I want to select distinct 'ServiceId' from CTE. I have following queryI have use simple inner join statement and gett