Forums
This topic is locked
Can I calculate in Query
Posted 03 Dec 2003 20:31:23
1
has voted
03 Dec 2003 20:31:23 Kobe Bryant posted:
Select fld1, fld2, fld3From tblOrder
Can I perform this in SQL query?
(fld1 * fld2) as Sum
Replies
Replied 04 Dec 2003 06:28:02
04 Dec 2003 06:28:02 Nozomi Kugita replied:
Sure you can.
SELECT field1, field2, field1 + field2 AS sumresult FROM tbl1
above SQL will return, value of field1, field2, and the result of additions, field1 and field2.
- Noz
SELECT field1, field2, field1 + field2 AS sumresult FROM tbl1
above SQL will return, value of field1, field2, and the result of additions, field1 and field2.
- Noz