獲取表的所有id的一對的最大值-有解無憂

我是 sql 的初學者，我想知道如何為兩個連接表的每個 id 獲取幾個整數的最大值？

到目前為止我做了什么：

SELECT 
  Reduced_T_Rappro_N.[Rente RES] AS Rente_RES, 
  Reduced_T_Rappro_N.[Montant capital constitutif] AS Montant_Capital_Consitutif_N, 
  [Reduced_T_Rappro_N - 1].[Montant capital constitutif] AS [ "Montant_Capital_Constitutif_N-1" ], 
  IIf(
    [Reduced_T_Rappro_N - 1].[Montant capital constitutif] = 0, 
    0, 
    (
      [Reduced_T_Rappro_N].[Montant capital constitutif] - [Reduced_T_Rappro_N - 1].[Montant capital constitutif]
    )/ [Reduced_T_Rappro_N - 1].[Montant capital constitutif]
  )* 100 AS [ "Evolution capital constitutif" ], 
  [Reduced_T_Rappro_N].[Montant Sous Rente], 
  [Reduced_T_Rappro_N - 1].[Montant Sous Rente], 
  (
    IIf(
      [Reduced_T_Rappro_N - 1].[Montant Sous Rente] = 0, 
      0, 
      (
        [Reduced_T_Rappro_N].[Montant Sous Rente] - [Reduced_T_Rappro_N - 1].[Montant Sous Rente]
      )/ [Reduced_T_Rappro_N - 1].[Montant Sous Rente]
    )
  )* 100 AS [ "Evolution montant sous rente" ], 
  Reduced_T_Rappro_N.[Montant rente initial] AS Montant_Rente_Initial_N, 
  [Reduced_T_Rappro_N - 1].[Montant rente initial] AS [ "Montant_Rente_Initial_N-1" ], 
  (
    IIf(
      [Reduced_T_Rappro_N - 1].[Montant rente initial] = 0, 
      0, 
      (
        [Reduced_T_Rappro_N].[Montant rente initial] - [Reduced_T_Rappro_N - 1].[Montant rente initial]
      )/ [Reduced_T_Rappro_N - 1].[Montant rente initial]
    )
  )* 100 AS [ "Evolution rente initial" ], 
  MAX(
    [Reduced_T_Rappro_N - 1].[Montant Sous Rente]   [Reduced_T_Rappro_N].[Montant Sous Rente]
  ) AS [ "Addition" ] 
FROM 
  Reduced_T_Rappro_N 
  INNER JOIN [Reduced_T_Rappro_N - 1] ON (
    Reduced_T_Rappro_N.[Rente RES] = [Reduced_T_Rappro_N - 1].[Rente RES]
  ) 
  AND (
    Reduced_T_Rappro_N.[Société] = [Reduced_T_Rappro_N - 1].[Société]
  ) 
GROUP BY 
  Reduced_T_Rappro_N.[Rente RES], 
  Reduced_T_Rappro_N.[Montant capital constitutif], 
  [Reduced_T_Rappro_N - 1].[Montant capital constitutif], 
  [Reduced_T_Rappro_N].[Montant Sous Rente], 
  [Reduced_T_Rappro_N - 1].[Montant Sous Rente], 
  Reduced_T_Rappro_N.[Montant rente initial], 
  [Reduced_T_Rappro_N - 1].[Montant rente initial];

我的查詢中的劃分對應于百分比進化的計算，此外，我使用 MS ACCESS 從中呼叫方法 iif

結果：

租用_RES	Montant_Capital_Consitutif_N	Montant_Capital_Consitutif_N-1	蒙坦特	Montant Sous Rente N-1	Evolution montant 慢租	Montant Rente 初始 N	Montant Rente 初始 N-1	添加
00000002-01	0	0	200,34	198,35	1,00327703554324	195,61	195,61	398,69
00000002-01	0	0	200,34	200,34	0	195,61	195,61	400,68
00000002-01	0	0	202,34	198,35	2,0115956642299	195,61	195,61	400,68
00000002-01	0	0	202,34	200,34	0,998302885095338	195,61	195,61	402,68
00000002-03	25070,68	25070,68	1583,2	1583,2	0	1472,18	1472,18	3166,4
00000003-04	0	0	1358,5	1340,93	1,31028465318845	1266,7	1266,7	2699,43
00000003-04	0	0	1358,5	1358,5	0	1266,7	1266,7	2717

我想要的是：每個 ID (Rente RES) 只獲得一個結果，對應于 [Montant sousrente N] 和 [Montant sousrente N-1] 之間加法的最大值。

租用_RES	Montant_Capital_Consitutif_N	Montant_Capital_Consitutif_N-1	蒙坦特	Montant Sous Rente N-1	Evolution montant 慢租	Montant Rente 初始 N	Montant Rente 初始 N-1	添加
00000002-01	0	0	202,34	200,34	0,998302885095338	195,61	195,61	402,68
00000002-03	25070,68	25070,68	1583,2	1583,2	0	1472,18	1472,18	3166,4
00000003-04	0	0	1358,5	1358,5	0	1266,7	1266,7	2717

uj5u.com熱心網友回復：

SELECT Reduced_T_Rappro_N.Rente_RES, Max(([Montant_Capital_Consitutif_N-1] [Montant_Capital_Consitutif_N])) AS Addition FROM Reduced_T_Rappro_N GROUP BY Reduced_T_Rappro_N.Rente_RES;

獲取表的所有 id 的一對的最大值

轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/429068.html

標籤：sql 毫秒访问

上一篇：Access中按識別因素分組的連續平均值

下一篇：FindFirst與日期值