MSSQL查询求最大时间对应的条码

[So_CooL]

MsSql在A表中取最大时间对应的条码，求助各位大神。

09UCE03P000002D9P1262292    2023-09-26 14:28:41
09UCE03P000002D9L1264925    2023-09-26 13:38:47
09UCE03P000002D9H1266881    2023-09-26 08:16:29
09UCE03P000002D9M1260241    2023-09-25 20:22:57
09UCE03P000002D9N1260185    2023-09-25 10:59:56
09UCE03P000002D9L1260498    2023-09-25 00:31:38
09UCE03P000002D9K1261566    2023-09-24 22:16:55
09UCE03P000002D9M1263203    2023-09-24 15:37:55
09UCE03P000002D9K1273268    2023-09-23 18:22:20
09UCE03P000002D9H1267304    2023-09-23 11:52:23

[吉普赛的歌]

下次发sql server版块吧。

USE tempdb
GO
IF OBJECT_ID('dbo.[t]') IS NOT NULL 
    DROP TABLE dbo.[t]
GO
CREATE TABLE dbo.[t](
[c1] VARCHAR(64)
,[c2] DATETIME
)
GO
SET NOCOUNT ON
INSERT INTO dbo.[t] VALUES(N'09UCE03P000002D9P1262292',N'2023-09-26 14:28:41')
INSERT INTO dbo.[t] VALUES(N'09UCE03P000002D9L1264925',N'2023-09-26 13:38:47')
INSERT INTO dbo.[t] VALUES(N'09UCE03P000002D9H1266881',N'2023-09-26 08:16:29')
INSERT INTO dbo.[t] VALUES(N'09UCE03P000002D9M1260241',N'2023-09-25 20:22:57')
INSERT INTO dbo.[t] VALUES(N'09UCE03P000002D9N1260185',N'2023-09-25 10:59:56')
INSERT INTO dbo.[t] VALUES(N'09UCE03P000002D9L1260498',N'2023-09-25 00:31:38')
INSERT INTO dbo.[t] VALUES(N'09UCE03P000002D9K1261566',N'2023-09-24 22:16:55')
INSERT INTO dbo.[t] VALUES(N'09UCE03P000002D9M1263203',N'2023-09-24 15:37:55')
INSERT INTO dbo.[t] VALUES(N'09UCE03P000002D9K1273268',N'2023-09-23 18:22:20')
INSERT INTO dbo.[t] VALUES(N'09UCE03P000002D9H1267304',N'2023-09-23 11:52:23')

----------- 以上为测试表及测试数据 -----------
SELECT TOP 1 t.c1 FROM t ORDER BY t.c2 DESC