Get unique values using STRING_AGG in SQL Server

by

Use the DISTINCT keyword in a subquery to remove duplicates before combining the results: SQL Fiddle

SELECT 
ProjectID
,STRING_AGG(value, ',') WITHIN GROUP (ORDER BY value) AS 
NewField
from (
    select distinct ProjectId, newId.value 
    FROM [dbo].[Data] WITH(NOLOCK)  
    CROSS APPLY STRING_SPLIT([bID],';') AS newID  
    WHERE newID.value IN (   'O95833' , 'Q96NY7-2'  )  
) x
GROUP BY ProjectID
ORDER BY ProjectID

More Related Contents:

  1. Produce DISTINCT values in STRING_AGG
  2. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  3. How do I create a comma-separated list using a SQL query?
  4. String_agg for SQL Server before 2017
  5. Get Parent with multiple children in desc order
  6. How can I schedule a job to run a SQL query daily?
  7. Convert Month Number to Month Name Function in SQL
  8. SQL Server 2012 column identity increment jumping from 6 to 1000+ on 7th entry [duplicate]
  9. Reset identity seed after deleting records in SQL Server
  10. How to avoid the “divide by zero” error in SQL?
  11. Multiple INSERT statements vs. single INSERT with multiple VALUES
  12. Limit on the WHERE col IN (…) condition
  13. Removing leading zeroes from a field in a SQL statement
  14. How to simulate UNPIVOT in Access?
  15. Get day of week in SQL Server 2005/2008
  16. Getting result of dynamic SQL into a variable for sql-server
  17. Better techniques for trimming leading zeros in SQL Server?
  18. SQL Server: Extract Table Meta-Data (description, fields and their data types)
  19. Dynamic Pivot Table in SQL Server
  20. Optimized SQL for tree structures
  21. How to insert a blob into a database using sql server management studio
  22. Joining multiple tables in SQL
  23. Get the character between first 2 special character in SQL
  24. Execution sequence of Group By, Having and Where clause in SQL Server?
  25. Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null
  26. SQL count consecutive days
  27. Add a column to existing table and uniquely number them on MS SQL Server
  28. How to execute a stored procedure inside a select query
  29. What is the most appropriate data type for storing an IP address in SQL server? [duplicate]
  30. SQL Inner Join On Null Values

Leave a Comment