QUERY

QUERY

SELECT * INTO [TMP_LASTDAY] FROM (
	SELECT [GRP_ID], MAX([YMD]) AS [YMD]
	FROM [tbl]
	GROUP BY [GRP_ID]
) [N];


SELECT [N].[GRP_ID], [N].[YMD_1W] INTO [TMP_1W] FROM (
	SELECT
		[TMP_LASTDAY].[GRP_ID],
		MAX([tbl].[YMD]) AS [YMD_1W]
	FROM [TMP_LASTDAY]
	LEFT JOIN [tbl] ON
		[TMP_LASTDAY].[GRP_ID] = [tbl].[GRP_ID] AND
		[tbl].[YMD] <= DATEADD(DAY, -7, [TMP_LASTDAY].[YMD])
	GROUP BY [TMP_LASTDAY].[GRP_ID]
) [N]

SELECT [tbl].*
FROM [TMP_1W]
LEFT JOIN [tbl] ON 
	[tbl].[GRP_ID] = [TMP_1W].[GRP_ID] AND 
	[tbl].[YMD] = [TMP_1W].[YMD_1W]