All language subtitles for 4. ROUND

Now let us look at the round function. Round is a very important function
1

You may have noticed that
2

Whenever you are transacting, you transact in integer values
3

The money that you gave to someone person, it is integer values usually
4

Where as the price written for various products is in decimal points
5

So
6

Whenever you are transacting you want to round that price
7

To the nearest integer
8

That's where round function helps you
9

The syntax for Round function is simple you just right round and give the
10

Number that you want to round
11

It'll round that number to the nearest integer
12

So for example I have sales values in the sales table
13

It has two decimal places
14

The round function will round it to the nearest integer
15

So let us find out the sales values and the its rounded values
16

So if you can see in the sales table
17

The sales value has
18

Two decimal values
19

If we round it
20

Let us see what we get
21

Select
22

Order line
23

Order line
24

the sales value and the rounded sales value
25

From
26

Sales
27

Ordered by sales in descending
28

Let's run this
29

So you can see 22638
30

Point 48
31

Is rounded to 22638
32

174199.95 is rounded to 17500
33

So
34

When we were using
35

Floor. it was always giving us the lower integer value
36

When we were using the
37

Ceiling, it was giving us only the higher integer value when you are rounding up
38

It will give you the nearest integer value
39

So that's the difference
40

Round is just
41

taking you to the nearest integer value to that
42

Decimal number that you've input