Now, it's time to discuss about the N R and the not operators in SQL. So, if you I hope you are familiar with and or not. So, this is the N or N same thing this is the or or say things and this is a lot or not. So, you know very well if you have condition one condition one and condition two if you have this end or this end between these two conditions, if you return to from here to from here that means, some particular code is executed if you use or or or this one that means, if you return this true or this false, it will automatically execute this statement. If you are using not. That means you are saying if this returns true, make it all because you're using art.

So this is very basic. Consider you have the basic knowledge of these operators. I hope you have. So, now I'm saying that please show me the address from students where the address is this. And if I'm using the end, make sure I'm going to do this. So you can easily I'm seeing an S ID and the S ID s ID equals two One so now I can hit control interest now as you can see, it's not showing any results because because you know very well that I'm saying just a second straight, you know very well that I am filtering the record who has this address so you can see it was the same.

So as you can see this row have three value and this oil value. So that's why there's not receiving any record because you are saying oh please use the where clause, where the address is this fine. This returns to, you are using the are, you are saying that s ID equals one. So as you can see here is the one ID is not available. So that's why and always execute If you return both two positions, this one and this one, okay? Ctrl, enter Ctrl Ctrl F, so you can see it's not returning.

If you're using the art, it will, using the R, it will return the records because this condition is true. So that's why it's retrieving the values from the tables. And why it's receiving this way, because this returns false. But this value returns to so that's why it's also correct. So that's why it's returning this way. Okay, if I'm saying that only show me where not equals to this call F. So as you can see your string the other Okay, so in this way your and or not operators work so it's totally depend upon you how you are creating the logic and what is your need and what is your requirement.

So it's fine. So thanks for watching