if i have a sql statement like so:
The output comes back as 1.6, how do i just round to two using the math round function?Code:SELECT quantity,duration_minutes, duration_seconds, quantity / SUM(duration_minutes + duration_seconds) as total From process_data GROUP BY quantity,duration_minutes, duration_seconds
Thanks in advance.


Reply With Quote
Bookmarks