SQL - Part 9 - Using Logical Operators (AND, OR, NOT)

[@QAFox]

For any doubts, live training updates and free Courses please join our Telegram channel t.me/qafoxoriginal

[@harish4010]

Can we use Not equal() instead of Not (logical ooerator) in statement condition.Does this both are same.

[@QAFox]

Yes, NOT != and are same

[@viveksuryanaraynan9478]

Instead of (select * from customer where NOT country='Germany';)
can we use (select * from customer where country'Germany';)
is this correct?

[@QAFox]

Yes, NOT != and are same

[@dishasondhiya6209]

Is this complete series is enough for cracking clg placement process?

[@QAFox]

I can't say this is enough. Apart from this series, prepare for the earlier interview questions asked on SQL at CLG.

[@suhas7230]

How to use the Multiple AND's like Country = " UK" and "USA". the same can be achieved by adding OR operator but is there a way we can add multiple and to attain the same?

[@mr_noob6361]

do u even know what u r telling?? u want to filter a record where it have 2 country name at a time😂😂

[@rahulk3209]

Sir when to use logical And operator and logical OR operator ?

[@rahulk3209]

For example
SELECT * From Customers where CustomerID=1 AND CustomerID=2;

[@QAFox]

@@rahulk3209 This is not correct, as there cannot be a single customer having same customer id. Lets say you can use to retrieve customers from a country and a state.

[@Anyam333]

sir we can use AND OR logical operators in one statement show me one example plz

[@partabparmar5537]

THANK YOU SIR

[@QAFox]

Most Welcome :)

[@abhihonrao4488]

THANKS MAN😊😊

[@QAFox]

Welcome 😊

[@amruthasankar3453]

Thankyou sir🤩🤩🤩🤩

[@QAFox]

Welcome :)

[@th3graduate292]

Thank you sir.

[@QAFox]

Welcome :)

[@thangamanip2819]

Awesome!!

[@QAFox]

Thank you! Cheers!

[@VivekSingh-sl9kz]

Good !!

[@QAFox]

Thank you