SQL Tutorial - 20: AND & OR Operators Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
the 20th tutorial in this course and in
this tutorial we are going to talk about
the and and all logical operators and
we've already seen the and and all
logical operators we know what they do
but you know I just wanted to have a
separate tutorial on these operators in
this course so the and and or operators
as you know by now are logical operators
and you know they are used for creating
complex conditions that you can you know
sort of implement using the where clause
and the and operator makes it necessary
for all conditions that you've joined in
the you know final condition to be true
while the or operator works even if you
know any one condition that's there in
the list of conditions evaluates to true
and we're going to check out a couple of
really simple applications of and all
I'm sure you guys have already you know
work quite a lot with that nor and you
know it might be a little boring for you
to you know just see this tutorial in
case you understood and an order
operators perfectly then you can
probably skip the rest of the tutorial
and you can move on in the course but if
you want to you know see some
applications again then you can sort of
stick with me for another couple of
minutes so let's get to the MySQL
workbench now so I'm going to create
some really simple conditions and
firstly I'll use the Select keyword and
the star symbol because I want to you
know see data from all the you know
fields in the table and then I'll type
in the from keyword in the name of the
table which is employee and then in the
next line I'll type in the where keyword
and you know the first condition that I
would want you know and the first
condition that I would want to implement
is that the salary must be let's say
greater than 15,000 right and the next
condition that I would want to implement
is that the age of the employees should
be less than 35 or let's make it 30
right and since I want both these
conditions to evaluate to true I would
have to put in the and operator here
right and if I would have wanted anyone
to evaluate for truth and I would have
used the or operator when I press
control enter I see that Howard has age
29 which is less than 30 and how
salary is also greater than 15,000 right
and Nick has age 25 which is less than
30 and Nick's salary is also greater
than 15,000 so you would see no record
in the results set for which the age is
greater than 30 and you would also not
see any record for which the value of
salary is less than 15,000 writes both
conditions you know would have
definitely been checked and the result
set would only contain records that
satisfy both conditions the next key
word is the or operator that we're going
to check out and the or operator makes
it necessary for any one condition to be
true right an application of the or
operator well you know let me just
modify this too or so now you would see
values that satisfy either the two
conditions so even employees with age
greater than 30 would figure in the list
and even employees with age you know
sorry less than 15,000 would figure in
the list right and we'll press control
enter there you go this time we see that
the Roger with age 32 is also in the
list and let's find out an employee with
salary less than 15,000 well we don't
have to look too far ahead John with age
22 has a salary of 22 that has a salary
of 12,500 which is less than 15,000 but
it's in the list because we've used the
or operator and the John satisfies one
of the two conditions that is John's age
at least as less than 30 right so that's
it about the and and or operators I'm
going to see you in the next tutorial in
which we discuss something important for
sure and please subscribe to my channel
in case you haven't already and I see
you soon