CODEWITHSUNDEEP
firebirdsummary
delphikar
delphikar

Reputation: 13

Firebird summary fields calculate

i want to do this :

select 
  id, 
  sum(field1) as a,
  sum(field2) as b,
  a - b as result group by id;

but firebird showing "Column unknown. a." error at line "a - b as result". How do make this. Thanks..

Upvotes: 0

Views: 134

Answers (1)

ain
ain

Reputation: 22749

Write the sum() out in the subtraction too, ie

select 
  id, 
  sum(field1) as a,
  sum(field2) as b,
  sum(field1) - sum(field2) as result 
group by id;

Upvotes: 1

Related Questions