Truncate on a select

Question

I have the following query:

SELECT     
 SUM(`SPEND_AMOUNT`) AS 'Total Spend Amount',
 SUM(`SPEND_AMOUNT`)  / COUNT(DISTINCT `INVOICENUMBER`) AS 'Average Spend Amount' 
FROM 
 `TABLE`

I would like to truncate(?) the results for "Average Spend Amount" to two decimal places.Thanks for the help.

Check this http://www.w3resource.com/mysql/mathematical-functions/mysql-truncate-function.php — Pardeep Dhingra, Jun 12 '15 at 17:07

score 0 · Answer 1 · answered Jun 12 '15 at 17:00

0

Round(SUM(SPEND_AMOUNT) / COUNT(DISTINCT INVOICENUMBER), 2)

answered Jun 12 '15 at 17:00

didando8a

130
1
7

Truncate on a select

1 Answers1