22,210
社区成员
发帖
与我相关
我的任务
分享
;WITH cte AS (
SELECT [客户],
min([跟进时间]) as [最小跟进时间]
FROM temp b
WHERE [更新客户状态] NOT IN ('陌生', '再次销售')
GROUP BY b.[客户]
)
SELECT
[客户]
,[最小跟进时间]
,(SELECT TOP 1 [转化时长] FROM temp a WHERE a.[客户]=b.[客户] and a.[跟进时间]=b.[最小跟进时间]) as [转化时长]
FROM cte b
;WITH cte AS (
SELECT 客户 ,
跟进时间 ,
转化时长
FROM temp
WHERE 更新客户状态 NOT IN ( '陌生', '再次销售' )
),cteb AS (
SELECT b.客户 ,
MIN(b.跟进时间) AS 跟进时间
FROM cte AS b
GROUP BY b.客户
)
SELECT cte.*
FROM cteb
JOIN cte ON cte.客户 = cteb.客户
AND cte.跟进时间 = cteb.跟进时间