SQL Tutorial - 36: Useful Numeric Functions Part-1 Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
the 36 tutorial in this course in this
tutorial we are going to check out a few
more numeric functions and the first one
that we're going to have a look at is
the seal function or the sealing
function and what this function does is
if you pass to it a number then it
returns the next higher integer right so
let's just see it in action I will bring
my cursor in the MySQL workbench window
and I'll type in select first and then
the name of the function which is C EIL
and then within parenthesis I will pass
a number argument and let me pass in 30
5.40 right so we know that the next
higher integer for this number is 36 so
if I would press control enter I would
see that in the results that I get 36 is
the answer right and you know you can
say that the counterpart of this
function is floor and what floor does is
it returns the you know next lower
integer to the number that's passed as
an argument so you know in case of 35.4
0 we know that the you know next lower
number is 35 right so when I would press
control enter I would get 35 as the
answer the result set for this for this
number right and the next function that
we're going to check out is the exp
function and what this does is it
returns a the power to the exponent base
which is known as e right and it
basically raises e to the power the
number that's passed in as an argument
right so if I would execute this
function with an argument 5 then I would
basically get e to the power 5 in the
result set right this should be close to
140 idea that's what it is
right so we know that the value of e is
close to 2.7 so if you would raise 2.7
to the power 5 this is you'll get get a
value that's similar to this right the
next function that we going to check out
is the natural log function and the name
of that function is a log and if suppose
you want to calculate the natural log of
2 you type in log and then within
parenthesis you just type in 2 and press
control enter and this is
where it is you know the natural log of
2 is 0.693 and if you want to calculate
the log of 2 to the base 10 that is not
the basis but base 10 and that value we
know is 0.3 0 1 0 so that you would get
by typing in log 10 as the function name
and not just log right and the next
function that we are going to check out
is the power function and I don't know
if we've discussed this function already
in this course not but this function
takes in two arguments and both have to
be numbers right so if suppose you want
to raise 2 to the power 7 let's say then
you type in 2 first and then put a comma
and then the second number which in this
case would be 7 but you know it could be
anything you know you could raise
anything to the power anything and press
ctrl + R you would see that 2 to the
power 7 128 so if you want to verify the
result of the EXP function that we got
earlier I know that the value of E is
you know I guess 2.718 and I guess we
raise it to the power 5 to get hundred
48 point something so yeah that's what
it is right and this is not the exact
value of Heat it's actually you know
recurring decimal so it's 2.718
something something something so if you
would raise it to the power 5 you would
get the exact answer right so that's the
the power function it's P or W and the
next one that we're going to check out
is the greatest function right it's not
actually the greatest function but the
name of the function is greatest so what
it does is it takes in a list of numbers
and it returns the highest number in the
list so let me give it a lab rat list
like 5 comma 3 comma 1 comma 77 comma 9
comma 11 comma 6 comma 3 comma 3 comma
89 right that's big enough and when I
press control enter I see that the
result said I get 89 and this is a very
useful function I'm sure that you know
people who haven't heard of this
function but are seeing it now for the
first time you know you guys must have
already started wondering about the kind
of things that you can do with this you
know I mean all those programs that we
make in you know programming languages
you know when we learn programming
languages to find out the largest of
three numbers six numbers
you know if you're doing scripting you
could use this function in the back and
you could do all those things so
conveniently right it's a very useful
function and then the counterpart of
this function is least right and what
this does is it returns the smallest
number in the list that's passed to it
as an argument so for this list if I
would execute I would get the answer is
1 because 1 is indeed the smallest
number and if I would change any of
these numbers to a negative number let's
say I'll take this to minus 77 now if I
would execute I would get minus 77 as a
result right because my 77 is a negative
value and it's obviously smaller than
all these so that's it for now I hope
you guys had fun watching this tutorial
I'll see you in the next one in which we
discuss something interesting for sure
and you may subscribe to my channel if
you haven't already and take care