Tutorial Gateway

SQL STRING_AGG Function

by

The SQL STRING_AGG is one of the String Function, which concatenates the string expressions, and places a specified separator in-between them. Remember, this function will not place a separator at the end of the string.

In this article we will show you, How to use/write STRING_AGG with an example.

SQL STRING_AGG Syntax

The basic syntax of the SQL Server STRING_AGG function is as shown below:

SELECT STRING_AGG (String_Expression, Separator)
FROM [Source]
GROUP BY Columns

The list of arguments available for STRING_AGG is as shown below:

  • String_Expression: Please specify a valid String Expression
  • Separator: Use VARCHAR, or NVARCHAR type. This function will use this separator in-between string concatenation
  • Group By: This is an option argument. Use this to perform grouping.

For this demonstration, we are going to use the below shown data

SQL STRING_AGG Function 1

SQL STRING_AGG Function Example 1

In this example, we will concatenate the Last name columns data using STRING_AGG function.

-- SQL Server STRING_AGG Function Example
USE [SQL Tutorial]
GO
SELECT STRING_AGG([LastName], ' , ') AS TextFile
  FROM [Employee]

OUTPUT

SQL STRING_AGG Function 2

SQL STRING_AGG Function Example 2

In this example, we are going to implement the Grouping along with String_Agg function.

-- SQL Server STRING_AGG Function Example
USE [SQL Tutorial]
GO
SELECT STRING_AGG([LastName], ' , ') AS TextFile
  FROM [Employee]
  GROUP BY Occupation

OUTPUT

SQL STRING_AGG Function 3

Thank You for Visiting Our Blog

Placed Under: SQL