Fórum Select somar e agrupar #622296

SELECT V.COD_BANCO, B.NOME as NOMEBANCO,
    SUM(V.total) AS TOTPAGO
FROM TBVENCIDAS V
    INNER JOIN tbbancos B
ON V.COD_BANCO = B.COD_BANCO
    WHERE V.DT_PAGAMENTO between '28.05.2024' and '29.05.2024'
GROUP BY V.COD_BANCO, B.NOME

qrAux.Close;
qrAux.SQL. Clear;
qrAux.SQL.Add('SELECT V.COD_BANCO, B.NOME as NOMEBANCO');
qrAux.SQL.Add('SUM(V.total) AS TOTPAGO');
qrAux.SQL.Add('FROM TBVENCIDAS V');
qrAux.SQL.Add('INNER JOIN tbbancos B');
qrAux.SQL.Add('ON V.COD_BANCO = B.COD_BANCO');
qrAux.SQL.Add('WHERE V.DT_PAGAMENTO = :pData'');
qrAux.SQL.Add('GROUP BY V.COD_BANCO, B.NOME');
qrAux.ParamByName('pData').asDate:= dtp.Date;
qrAux.Prepare;
qrAux.Open;