Gwongwuri ROUND() a SQL

ROUND() Fon ki

ROUND() Fon ki don kaiwa burin burin duki a matsayin burin burin da a kaiwa.

Shi ne ƙasiddan SQL ROUND()

SELECT ROUND(column_name,decimals) daga table_name
Parameters Bayani
column_name Wajib. Duki da ake so a kaiwa burin burin.
decimals Wajib. Shekarun da ake so a kaiwa burin burin.

Shi ne ƙasiddan SQL ROUND()

A kaiwa da wannan "Products" tabbin:

Prod_Id ProductName Unit UnitPrice
1 gold 1000 g 32.35
2 silver 1000 g 11.56
3 copper 1000 g 6.85

A yanzu, a rini sunan da kwayar da kaiwa maimakon burin burin.

A kaiwa da SQL a yanzu:

SELECT ProductName, ROUND(UnitPrice,0) as UnitPrice FROM Products

Gudanin shida yana kwanan kwanan kwanan:

ProductName UnitPrice
gold 32
silver 12
copper 7