[firebase-br] Luz para sql Firebird - Help-me

[Marcio Da Silva Ereno]

Marcio
tenta
 colocar order by "Frete"."Data"
e first 1 para pegar somente o primeiro registro


SELECT *first 1* DISTINCT
  SUM("Frete"."Frete_Bruto") AS "Bruto",
  SUM("Frete"."
ComissaoMotorista") AS "Comissao",
  SUM("Frete"."Totalkm") AS "Kilometragem",
  CAMINHAO.P_CAVALO,
  SUM("Frete"."Frete_Limpo") AS "Liquido",
  SUM("Frete"."Peagio") AS "Pedagio",
  SUM("Frete"."LitrosTotal") AS "Diesel",
  SUM("Frete"."DieselGeral") AS "ValorDiesel"
FROM
 "Frete"
 INNER JOIN CAMINHAO ON ("Frete"."Cod_Caminhao"=CAMINHAO.CAM_CODIGO)
WHERE
  ("Frete"."Data" BETWEEN '01/01/2011' AND '01/01/2012')
GROUP BY
  CAMINHAO.P_CAVALO
*order by "Frete"."Data" *

Abraço
-- 
*Marcio da Silva Ereno*
          *Analista de Sistemas*
*MSEreno - Assessoria & Sistemas*
         www.msereno.com.br