var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: db2 query help
we r facing problem in DB2 7.2.3 database on win2000 server.
I need something like:
Count(Field1) as f1 , count(field2) as f2, (f1+f2) as f3 from table where..................
In MS access it can be done as (f1+f2) as f3 , but how to do it in DB2 to dynamically sum the result of query?
urgent help needed
Last edited by subhash13; 08-18-03 at 07:11.
Why not do it this way:
Count(Field1) as f1 , count(field2) as f2, (Count(Field1) +count(field2) ) as f3 from table where....