WITH c1(ID, 记录值)
AS
(
SELECT 1, 3000 UNION ALL
SELECT 2, 3200 UNION ALL
SELECT 3, 3500 UNION ALL
SELECT 4, 3500 UNION ALL
SELECT 5, 3700 UNION ALL
SELECT 6, 3900 UNION ALL
SELECT 7, 3900 UNION ALL
SELECT 8, 3500 UNION ALL
SELECT 9, 4100
)
----start query
,c2 AS
(
SELECT
b.ID,
CASE WHEN a.记录值 = b.记录值 THEN NULL ELSE b.记录值 END 记录值
FROM c1 a
LEFT JOIN c1 b ON a.ID = b.ID - 1--(b大)
UNION ALL
SELECT TOP 1
ID,
记录值
FROM c1
)
SELECT *
FROM c2 WHERE c2.记录值 IS NOT NULL
ORDER BY ID
Sql中如何实现连续相同的数据只取第一条
最新推荐文章于 2024-07-04 16:29:03 发布