Aynı Tablo İçerisinde Sql Çıkarma İşlemi

Aşağıdaki şekilde deneyiniz;

SELECT [t1].[KOD], ([t1].[AY] + '-') + ((
SELECT [t3].[AY]
FROM (
SELECT TOP (1) [t2].[AY]
FROM [<TABLONUZ>] AS [t2]
WHERE ([t2].[AY] <> [t1].[AY]) AND ([t2].[KOD] = [t1].[KOD])
ORDER BY [t2].[AY] DESC
) AS [t3]
)) AS [AY], [t1].[value] - ((
SELECT [t5].[FIYAT]
FROM (
SELECT TOP (1) [t4].[FIYAT]
FROM [<TABLONUZ>] AS [t4]
WHERE ([t4].[AY] <> [t1].[AY]) AND ([t4].[KOD] = [t1].[KOD])
ORDER BY [t4].[AY] DESC
) AS [t5]
)) AS [FIYAT]
FROM (
SELECT MAX([t0].[FIYAT]) AS [value], [t0].[AY], [t0].[KOD]
FROM [<TABLONUZ>] AS [t0]
GROUP BY [t0].[AY], [t0].[KOD]
) AS [t1]