DECLARE @TB TABLE([ID] INT, [地点] NVARCHAR(2), [气温] INT) INSERT @TB SELECT 1, N'上海', 30 UNION ALL SELECT 2, NULL, N'31' UNION ALL SELECT 3, NULL, N'31' UNION ALL SELECT 4, N'北京', 25 UNION ALL SELECT 5, NULL, N'26'UPDATE @TB SET [地点]=(SELECT TOP 1 [地点] FROM @TB WHERE ID<T.ID AND [地点] IS NOT NULL ORDER BY ID DESC) FROM @TB T WHERE [地点] IS NULLSELECT * FROM @TB
老大我想让这语句在access中实现应该咋改啊 UPDATE @TB SET [地点]=(SELECT TOP 1 [地点] FROM @TB WHERE ID<T.ID AND [地点] IS NOT NULL ORDER BY ID DESC) FROM @TB T WHERE [地点] IS NULL
SELECT * FROM TABLE t WHERE ISNULL(地点,(SELECT 地点 FROM TABLE WHERE ID=T.ID-1))
INSERT @TB
SELECT 1, N'上海', 30 UNION ALL
SELECT 2, NULL, N'31' UNION ALL
SELECT 3, NULL, N'31' UNION ALL
SELECT 4, N'北京', 25 UNION ALL
SELECT 5, NULL, N'26'UPDATE @TB SET [地点]=(SELECT TOP 1 [地点] FROM @TB WHERE ID<T.ID AND [地点] IS NOT NULL ORDER BY ID DESC)
FROM @TB T
WHERE [地点] IS NULLSELECT *
FROM @TB
UPDATE @TB SET [地点]=(SELECT TOP 1 [地点] FROM @TB WHERE ID<T.ID AND [地点] IS NOT NULL ORDER BY ID DESC)
FROM @TB T
WHERE [地点] IS NULL