34,587
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([编码] nvarchar(23),[水量] int,[抄表时间] nvarchar(39))
Insert #T
select N'001',10,N'2018 06 15 21:22:50' union all
select N'001',20,N'2018 06 15 22:22:50' union all
select N'001',25,N'2018 06 15 21:28:50' union all
select N'002',21,N'2018 06 15 01:22:50' union all
select N'002',5,N'2018 06 15 21:28:50' union all
select N'003',10,N'2018 06 15 11:28:50'
Go
--测试数据结束
SELECT *
FROM
(
SELECT *,
ROW_NUMBER() OVER (PARTITION BY 编码 ORDER BY 抄表时间 DESC) rn
FROM #T
) t
WHERE rn = 1;