[SOLVED] Decimals in a query

[TimUSA]

I am using this query, how do i limit the decimals on the return for avg()

SELECT skipperName, sum( fleetPoints ) AS SumfleetPoints, avg( fleetPoints ) AS rating, count( fleetPoints ) AS races
FROM pts_table
WHERE fleetPoints >0
GROUP BY skipperName
ORDER BY rating DESC , SumfleetPoints, races ASC 

[p2grace]

Try this:

 

SELECT skipperName, sum( fleetPoints ) AS SumfleetPoints, truncate(avg( fleetPoints ),2) AS rating, count( fleetPoints ) AS races
FROM pts_table
WHERE fleetPoints >0
GROUP BY skipperName
ORDER BY rating DESC , SumfleetPoints, races ASC