SELECT CardNo,Balance,Stamp
FROM dbo.cl_Transactions_2018_05 T
WHERE not EXISTS
( SELECT CardNo,Balance,Stamp FROM dbo.cl_Transactions_2018_05 WHERE CardNo = T.CardNo AND Stamp > T.Stamp )
多表查询
SELECT CardNo,Balance,Stamp
from dbo.cl_Transactions_2022_07,dbo.cl_Transactions_2022_08,dbo.cl_Transactions_2022_09.dbo.cl_Transactions_2022_10,dbo.cl_Transactions_2022_11dbo.cl_Transactions_2022_12,
dbo.cl_Transactions_2023_01,dbo.cl_Transactions_2023_02,dbo.cl_Transactions_2023_03,dbo.cl_Transactions_2023_04,dbo.cl_Transactions_2023_05,dbo.cl_Transactions_2023_06,dbo.cl_Transactions_2023_07,dbo.cl_Transactions_2023_08,dbo.cl_Transactions_2023_09,dbo.cl_Transactions_2023_10,dbo.cl_Transactions_2023_11,dbo.cl_Transactions_2023_12,
dbo.cl_Transactions_2024_01,dbo.cl_Transactions_2024_02,dbo.cl_Transactions_2024_03,dbo.cl_Transactions_2024_04,dbo.cl_Transactions_2024_05 T
where not exists
(SELECT CardNo,Balance,Stamp FROM dbo.cl_Transactions_2022_07,dbo.cl_Transactions_2022_08,dbo.cl_Transactions_2022_09.dbo.cl_Transactions_2022_10,dbo.cl_Transactions_2022_11dbo.cl_Transactions_2022_12,
dbo.cl_Transactions_2023_01,dbo.cl_Transactions_2023_02,dbo.cl_Transactions_2023_03,dbo.cl_Transactions_2023_04,dbo.cl_Transactions_2023_05,dbo.cl_Transactions_2023_06,dbo.cl_Transactions_2023_07,dbo.cl_Transactions_2023_08,dbo.cl_Transactions_2023_09,dbo.cl_Transactions_2023_10,dbo.cl_Transactions_2023_11,dbo.cl_Transactions_2023_12,
dbo.cl_Transactions_2024_01,dbo.cl_Transactions_2024_02,dbo.cl_Transactions_2024_03,dbo.cl_Transactions_2024_04,dbo.cl_Transactions_2024_05 WHERE CardNo = T.CardNo AND Stamp > T.Stamp )
单表查询可行，多表查询不会写，求助完善下
CardNo取多表唯一值，Stamp取多表最新时间
