For the query
SELECT round(143.23, -1)
The second parameter indicates how many digits of precision after the decimal point you want to preserve. Thus,
-1 means one digit before the decimal point. I.e., you're losing the "ones" digit and rounding to the nearest "tens", resulting in
To get a whole number (
143 in this case), you can pass 0 as the second parameter, or just omit it entirely, as that's the default.