英[ra?nd] 美[ra?nd]

adj. Round; arc-shaped; plump, fat; integer

adv. Everywhere; around; roundabout ; in the opposite direction

prep.approximately; around, surrounding; (indicating position) around; nearby

n. circle, circle; cycle; round object, spherical object; (Meeting) One round

vt.& vi. Make a circle; go around; turn around; round...

Third person singular: rounds Plural: rounds present participle : rounding Past tense: rounded Past participle: rounded Comparative: rounder Superlative: roundest

mysql ROUND() function syntax

Function: Used to round numerical fields to the specified number of decimal places.

Syntax: SELECT ROUND(column_name,decimals) FROM table_name

##Parameters:

ParameterDescriptioncolumn_name Required. The field to round. decimals Required. Specifies the number of decimal places to be returned.

mysql ROUND() function example

//把名稱和價(jià)格舍入為最接近的整數(shù)。
SELECT ProductName, ROUND(UnitPrice,0) as UnitPrice FROM Products;