這是一個 island and gap problem 解法可以參考下面 SQL Server 版本 DECLARE @v NVARCHAR(MAX) = N'...
CREATE TABLE TMP ( SETSTR NVARCHAR(50)); INSERT INTO TMP VALUES (N'庭院深深深幾許繼光香香香...
SELECT ym,vendor,SUBSTRING_INDEX(GROUP_CONCAT(product),",",2) FROM (...
check select * from ( select rank() over(partition by vendor,trunc(ex...
CREATE TABLE tab ( exdate date , vendor char(2) , product Nvarchar(20) );...
一級屠豬士的鐵人檔案