i have following query where i need 3rd column values comma separated which am getting it now but i need distinct values how can i do it?
WITH SelectedData As (
SELECT Distinct
[R].[Name],
COUNT(Distinct OFR.HeaderId) AS OfferCount,
STRING_AGG(CAST([OFR].[HeaderId] AS NVARCHAR(MAX)), ',') as [Ids]
FROM
[Mapping].[OFR] OFR
JOIN [Master].[R] R ON R.id = OFR.RId
JOIN [Transaction].[OH] OH ON OH.id = OFR.HeaderId
WHERE
OH.PId = 3
AND [OFR].[IsActive] = 1
AND [R].[IsActive] = 1
AND [OH].[IsActive] = 1
AND [U].Id = 173 AND [OFR].[RId] in (50) GROUP BY R.Name, OFR.RId )
SELECT *,COUNT(1) OVER() as [TotalRows] from SelectedData
Order by [Name] OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY