Original subtitles

0 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