SQL Tutorial - 34: ROUND() Function Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
the 34th tutorial in this course and in
this tutorial we are going to check out
another numeric function and this one is
the round function that it's used to
round off numbers right so let me you
know just show you guys a few examples
and then we talk about the round
function so if suppose you want to round
off you know a number to you know the
nearest decimal point right let's say if
you want to round out a round off fifty
four point seven eight three two
you know the nearest decimal point then
you use the round function and you have
to first type in select and then the
name of the function which is round then
within parenthesis you'd have to you
know type in the number that you want to
round off and you know in this case it's
fifty four point seven eighty three when
I press control enter I get fifty five
as the answer right so you know when you
use the round function this way that is
when you pass just one argument to it
you know SQL assumes that you want to
round the number of to the nearest
decimal place right so it assumes that
you don't want to see anything after the
decimal point but you know this is the
same as saying that you know round off
this number two you know zero digits
after the decimal point so if you would
execute this query you would still get
fifty five as the answer but if suppose
you want to see one digit after the
decimal point after the number has been
done it off like for this number fifty
four point seven eight three if you
would round this off to one decimal
point you know then the answer that you
would get would be fifty four point
eight so let's execute the coin there
you go you see that the answer is fifty
four point eight and if you would run it
off to two digits after the decimal
point then the answer would be 54 point
seven eight right because after eight
you have three and since 3 is less than
five you know I'm not going to discuss
rounding off rules in this tutorial but
you know if suppose I change this three
to seven and now if I would execute this
way then you would get 54 point seven
nine instead right because number now is
87 so you know it's closer to 90 than it
is to eighty right but if I have three
here then 83 is closer to 80 than it is
to 90 so that's why
we had fifty fifty four point seven
eight is the answer for this one and our
thing is if suppose you want to round
off a negative number like minus twelve
point five seven try it and let me
remove this too and put in a zero there
if you would execute this query then you
would get minus thirteen is the answer
right so the number has been rounded to
the nearest you know decimal point and
you know same rounding rules rounding
off rules apply to positive as well as
negative numbers you know basically it's
you know the distance from zero is is
considered you know not the signs so you
know I mean if this was positive twelve
point five seven you would still get the
same on so you know you would still get
thirteen for it and you know if it's
minus twelve point you know five seven
you would get minus thirteen is the
answer so I hope you guys will stand the
point but anyway let's check on an
application of the round function so
what we're going to do is we are again
going to use the same two tables
tutorial as well as tutorial to score
info table we join them and get some
information out but what we're going to
get out is the average number of likes
you know for all the videos you know
group by these subjects right so in one
of the tutorials we saw the total number
of likes and total number of views for
all the tutorials grouped by different
subjects in this industry tour we're
going to check out the average number of
likes right so the query is going to be
select and then d dot subject and then
I'll type in ABG which is an aggregate
function and in the parentheses as an
argument I'll pass
TI dot likes and then I would type in
from and then T dot sorry from tutorial
as T join tutorial underscore info as TI
and then is there anything else that I
have to put in here of course the on
flaws in the condition which is T dot ID
equals tutorial underscore ID and I also
have to put in group by since I want the
you know data to be grouped by subject
so T dot subject would go in there put a
semicolon determinate the statement and
there you go you see that you know the
subject C has I mean all the roles in
subject C on an average have thirty
hundred forty one point one two five
zero likes and all tutorials in in the
shell scripting course have on an
average twelve hundred eighty nine point
seven five likes and all tutorials in
the SQL so playlists have on an average
fifty fifty two point four zero zero
likes but since we know that there is no
such thing as 0.125 like or you know
0.75 zero like you know whether you like
or whether you don't like this no such
thing is point one two five zero like of
course you could say that you know since
we are discussing averages here you know
it makes sense to have some you know
floating value as the result but if
suppose you just want to see the you
know likes or views data you know
rounded off to the nearest decimal then
for that case you know it for such a
thing you'll have to use the round
function and you just type in round here
around the average function average
aggregate function here and you know
let's let's make it a little more
readable so I'll type in as you know the
average number of likes rounded off to
the nearest decimal point right so this
makes a bit more sense I mean I would
execute this query you would see that
see tutorials now on an average have
1341 likes and shares fifteen euros now
on an average have two hundred ninety
likes and SQL tutorials now on an
average have fifty-two likes so anyway
that's it about the
function in the next tutorial we'll
check out another you make function and
thank you so much for watching this one
I assume in the next tutorial and you
may subscribe to my channel if you
haven't already and as usual