SQL SERVER 2017中的对应GROUP_CONCAT() [英] Corresponding GROUP_CONCAT() in SQL SERVER 2017

问题描述

我想将以下MYSQL查询转换为MS SQL Server.但是，我确定GROUP_CONCAT在2017年之前的MS SQL Server中不存在.SQLSERVER 2017中有一个功能.有人可以帮助我吗?

I want to convert the following MYSQL query to MS SQL Server. But, I am sure that GROUP_CONCAT doesn't exist in MS SQL Server prior to 2017. There is a function in SQL SERVER 2017. Can anyone help me?

SELECT region, GROUP_CONCAT(route_name) AS route_name 
FROM route_details 
LEFT JOIN ride_details ON route_id = r_id 
WHERE region != '' AND service_date = '2019-09-02' 
GROUP BY region

推荐答案

您要

You want string_agg(). The syntax is a bit different (typically, the separator is mandatory, while it defaults to , in MySQL, and SQLServer wants within group for the order by ):

SELECT region, STRING_AGG(route_name, ',') AS route_name 
FROM route_details 
LEFT JOIN ride_details ON route_id = r_id 
WHERE region != '' AND service_date = '2019-09-02' 
GROUP BY region

这篇关于SQL SERVER 2017中的对应GROUP_CONCAT()的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！