SQL Tutorial - 33: ABS() Function Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
the 33rd tutorial in this course and in
this tutorial we are going to begin our
discussion on numeric functions and the
first function that we're going to check
out is the absolute function and it's
the ABS function in in SQL and the
absolute function those of you have you
know some kind of programming experience
you know the you know I'm sure you guys
know that the absolute function returns
the distance of a number from zero right
so if a number is positive you know
let's say 27 then the absolute value of
that number would be 27 but if suppose
that number is on the negative side of
the number line you know then the
distance of the number from zero would
still be a positive number right so it
gives you the distance it doesn't tell
you whether the number lies on the right
side of the number line or right side of
zero on the number line or whether it
lies on the left side of zero on the
number line so the way you use absolute
function is you know I'll get my cursor
in the window so select ABS and then
within parenthesis you type in a number
right so I'll type in 15 and just
execute the query and there you go you
see that you know the absolute value of
15 is 15 and if I would type in a
negative sign here and if I would
execute the query you would see that the
absolute value minus 15 is also 15 and
you know the reason for that is you know
what I told you in the beginning the
dear old so let's not check out an
application of the absolute function so
what I'm going to do is I'll use the two
tables with which we worked the tutorial
table and the tutorial underscore info
table and you know I'll pull out
information from both the tables using a
join but you know I would also see the
absolute difference of the number of
likes and dislikes for all the tutorials
right so the number of dislikes can be
greater than number of likes for some
dude all right if people don't like you
know something at all then probably
there'll be more dislikes than likes
right but if you use the absolute
function to get the difference of the
number of likes and dislikes then you
would never see a negative number in
your result set right so let me just
demonstrate this I'll type in
select first and as in the previous
tutorials I will be using the alphabet T
to refer to the tutorial table and TI to
refer to the tutorial underscore info
table so I will type in T door title
because the title column is present in
the Royal table and I will put a comma
and we're actually on the next line I
will type in ABS and within parenthesis
I'll type in Ti dot likes - di dot
dislikes and display this has difference
of likes and dislikes right that's cool
enough then on the next line I will type
in from tutorial as T and then join
tutorial underscore info as T I type in
on and then the condition for join which
would be T dot ID equals T i dot
tutorial underscore ID for a semicolon
when I execute this query you would see
that I get the difference of likes and
dislikes for all the tutorials right so
for select query tutorial the likes are
probably you know forty one greater than
the number of dislikes and you know for
insert query tutorial the likes are
probably greater than the dislikes by
twenty two so you know with this kind of
results that you cannot tell whether the
number of likes are greater than number
of dislikes order the number of dislikes
greater than likes right that that's
something that you cannot tell if you
use the abs function right but then
sometimes you have to use it you know if
you do not want to display negative data
on the screen you just want to show
positive data you know if you if you're
just talking about differences between
quantities and you're not really
concerned about whether one quantity
whether you know the quantity a is
greater than quantity B or whether B is
greater than a no if you're not looking
to get into that kind of stuff than
absolute function is
is something that you can use so anyway
thank you so much for watching this one
in the next tutorial we'll discuss
another numeric function and you can
subscribe to my channel if you haven't
already and I'll see you in the next
tutorial