テーブル内の列に日付別に追加された新しい値を見つけるにはどうすればよいですか?
私はクライアントの契約番号の列があるテーブルを持っていますが、比較を行いたいのですが、前日に X 件の契約があり、当日に余分な契約番号があった場合、これらの新しい契約は「新しい契約」と表示され、前日の契約が当日の契約の列で消えている場合は「契約終了」と表示されます。
どうすればそれができるでしょうか?
私のテーブルの写真:
OBS: テーブルの名前: 「ECCR28」、使用したい列は契約の列である「CC」、契約日を表す「DATE」です。
TABLE CSV: `"","AGENCIA","REFERENCIA","CD_PRODUTO","CC","NM_CLIENTE","OPERACAO","VL_LIMITE","VL_UTILIZADO","PC_TAXA","DT_CONTRATO","TP_CONTRATACAO","DT_VENCIMENTO","INDICADOR_SEGURO","DT_VENC_SEG","ST_CONTRATO"
"1","0011",2022-12-07,"0026","011002845-7","WARLEN TANIOS NEMER","01100284570026008","4.000,00","0,00"," 100,00",2015-09-29,"PA",2023-09-08,"S",2023-09-29,"ATIV"
"2","0011",2022-12-07,"0026","011003535-6","EDUARDO RIBEIRO DOS SA","01100353560026001","1.400,00","0,00"," 100,00",2022-05-03,"AS",2023-05-03,"N",NA,"ATIV"
"3","0011",2022-12-07,"0026","011003803-7","LAZARO GOMES DE MOURA","01100380370026002","2.600,00","0,00"," 100,00",2022-05-03,"AS",2023-05-03,"N",NA,"ATIV""49","0011",2022-12-08,"0026","011002845-7","WARLEN TANIOS NEMER","01100284570026008","4.000,00","0,00"," 100,00",2015-09-29,"PA",2023-09-08,"S",2023-09-29,"ATIV"
"50","0011",2022-12-08,"0026","011003535-6","EDUARDO RIBEIRO DOS SA","01100353560026001","1.400,00","0,00"," 100,00",2022-05-03,"AS",2023-05-03,"N",NA,"ATIV"
"51","0011",2022-12-08,"0026","011003803-7","LAZARO GOMES DE MOURA","01100380370026002","2.600,00","0,00"," 100,00",2022-05-03,"AS",2023-05-03,"N",NA,"ATIV"
"52","0011",2022-12-08,"0026","011003988-2","RODRIGO MENNA BARRETO","01100398820026001","1.200,00","1629,75"," 100,00",2020-12-15,"AA",2021-12-14,"N",NA,"VENC"`