Syntax:-
ROUND ( numeric_expression , length [ ,function ]
numeric_expression :-Expression of the exact numeric or approximate numeric data type category, except for the bit data type.
length:- Optional.Must be an expression of type tinyint, smallint, or int. When length is a positive number, numeric_expression is rounded to the number of decimal positions specified by length. When length is a negative number, numeric_expression is rounded on the left side of the decimal point, as specified by length.
function:-Function must be tinyint, smallint, or int. When function is omitted or has a value of 0 (default), numeric_expression is rounded. When a value other than 0 is specified, numeric_expression is truncated.
Examples:-
1) Select Round(234.32,-3)
Result:-
0.00
2) Select Round(234.32,-2)
Result:-
200.00
3) Select Round(234.32,-1)
Result:-
230.00
4) select Round(234.32,0)
Result:-
234.00
5) Select Round(234.32,1)
Result:-
234.30
6) Select Round(234.32, 2)
Result:-
234.32
7) Select Round(234.32,3)
Result
234.32
Pingback: Dentist in Abilene Texas
Pingback: ขายฝาก ที่ดิน คือ อะไร
Pingback: roofing companies rhode island
Pingback: GCLUB
Pingback: Electricity Companies near me
Pingback: แบบ บ้าน พร้อม แปลน
Pingback: tree service nashville tn
Pingback: Charlotte Johansson
Pingback: Rage quit
Pingback: increase google rank
Pingback: Togelsumo
Pingback: บาคาร่า
Pingback: 바카라사이트
Pingback: รักษาหลุมสิว
Pingback: ศัลยà¸à¸£à¸£à¸¡à¹€à¸à¸²à¸«à¸¥à¸µ
Pingback: Beverly Hills 90210 Season 10 fmovies
Pingback: 바카라사이트
Pingback: road cases decals
Pingback: ทิงเจอร์ขาว
Pingback: botox
Pingback: scam
Pingback: Investments in Nigeria
Pingback: CBD oil
Pingback: copy Hublot Chronograph
Pingback: how to lose weight fast
Pingback: Tochka Market
Pingback: Cryptonia Market Exit Scam
Pingback: https://novushub.com/hindi-gana-video/
Pingback: partenariat influenceur
Pingback: แทงบอลออนไลน์
Pingback: cdr qq