Fórum Pesquisa SQL de MESES com GROUP BY e ORDER BY juntos #533789

    with dados.qryFaturamentoMes do
    begin
      close;
      sql.Clear;
      sql.Add('SELECT MONTH(DATA) & "/" & YEAR(DATA) as MesAno, SUM(VALOR_CASA) as TotalVendido FROM  historico ');
      sql.Add('where (DATA between :DATAINICIAL and :DATAFINAL)');
      sql.Add(' and (TIPO = "V") ');
      sql.Add(' group by MONTH(DATA) & "/" & YEAR(DATA) order by MONTH(DATA) & "/" & YEAR(DATA) ');
      Parameters.ParamByName('DATAINICIAL').Value := dataini;
      Parameters.ParamByName('DATAFINAL').Value := datafin;
      Open;
    end;