SQL Tutorial - 15: Arithmetic Operators Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
the 15th tutorial in this course and in
this tutorial we are going to talk about
operators in SQL and specifically about
arithmetic operators so what are
operators the symbols that you see on
the screen in the first bullet
you know the addition symbol the
subtraction symbol multiplication
division and then you know if you want
to perform operations such as finding
out which number is lesser you know if
you have two numbers and if you find out
if you have to find out which number is
the lesser of the two or which number is
if you know greater of the two or you
know whether two numbers are equal or
not so if you want to perform all those
kinds of tests then you have to use
operators right and operators are these
symbols that you use to perform you know
operations such as you know addition
multiplication subtraction when you are
talking about arithmetic operations and
you know finding out you know which
quantity is what in comparison to some
other quantity you know when you're
talking about relational operators or
relational operations right so the
operators in SQL are generally used with
the where clause and obviously you know
when you would use the relational
operators you would be limiting the
number of rows that you would obtain in
the result set
right so operators are used to limit the
number of rows that you get in the
output so there are four kinds of
operators that we have in SQL arithmetic
operators comparison logical and reverse
operators and we're going to check all
of them out right so we're going to
start with arithmetic operators and we
have five arithmetic operators available
for use in SQL these are the addition
subtraction multiplication division and
modular division operators right and
I'll talk about what modular division is
those of you who have you know a
background in programming would be
knowing what the percentage operator
does but those of you who don't know
just relax we're going to see it in
action in just a minute right so for
this tutorial I'm not going to use the
MySQL workbench instead I'm going to use
the command-line client and I'll be
doing this every once in a while because
you know it's it's always nice to be
accustomed to both environments right
the command-line interface as well as
the GUI interface because we don't know
what
you know our organization might ask us
to work on you know if you're thinking
about finding a job in SQL then you
should be equally proficient you know in
both the environment so next we're going
to check out all these operators so I
have my MySQL command line client here
and the prompt is currently asking me
for my password so I'm going to type in
that when I press the Enter key
I get the Welcome message and I also get
the MySQL you know prom wherein I can
type in my commands and the way I'm
going to demonstrate the commands to you
guys is by using the Select command that
we checked out in the previous tutorial
so let's say you want to add two
quantities right so the first thing that
you'll have to do is type in the keyword
select right and then the quantities
that you have to add along with the
addition operator right so if I have to
add 5 and 10 I'll type in 5 and then the
addition symbol and then I'm putting in
space characters around the addition
operator that's not necessary right but
I'm just putting in that so that you
know it's easy for you to understand so
when I press the Enter key now I get in
the result set 5 plus 10 is 15 right and
if I want to subtract let's say 5 from
10 then I'd use the subtraction operator
put in a semicolon press the Enter key I
get 5 again and then if I want to
multiply 5 and 10 again the first
operand and then you know the operate
operator which is the Astrix symbol in
this case and then the second operand
and the semicolon in the enter key gives
us 5 times 10 is 50 and then if I divide
10 by 5 I'll have to use the division
operator and when I press the Enter key
I get the result is 2 now the last
operator the last arithmetic operator
that you're going to talk about is the
modular division operator and what that
allows you to do is it allows you to
find the remainder when you divide one
quantity by another right so let's say
you are dividing 10 by 5 in that case
the remainder is 0 because 5 perfectly
divides 10 but if you're dividing a
number that doesn't you know get
perfectly divided by you know the
or what do you call divisor then you
know in that case you have some number
left as the remainder so the modular
division operator or the percentage
symbol allows you allows us to find that
you know remainder value so if you are
dividing let's say ten by three right so
let me first get in the percentage
symbol as my modular division operator
and if I type in three and put in the
semicolon press the Enter key
I get the remainder as one right and
this is because three times three is
nine and you know nine plus one is ten
so when you divide 10 by 3 you get a
remainder value of one so these are the
five earth Matic operators and we'll be
using them quite often in lots of
different ways in the you know future
tutorials so I hope you guys had fun
watching this one and please subscribe
to my channel in case you have already
and as you soon