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

Подписаться 94 тыс.

Просмотров 53 тыс.

50% 1

Join this channel to get access to perks:
/ @qafox
Refer www.qafox.com/ for all my free courses on Software Testing Concepts and Tools.
View Notes Here - www.evernote.com/l/AbENXhQZhtt...
In this video, I have explained and practically demonstrated using Logical Operators in SQL statements.

Наука

Опубликовано:

21 апр 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 22

@QAFox 7 месяцев назад

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

@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?

@th3graduate292 11 месяцев назад

Thank you sir.

@QAFox 11 месяцев назад

Welcome :)

@amruthasankar3453 Год назад

Thankyou sir🤩🤩🤩🤩

@QAFox Год назад

Welcome :)

@abhihonrao4488 5 месяцев назад

THANKS MAN😊😊

@QAFox 5 месяцев назад

Welcome 😊

@thangamanip2819 3 месяца назад

Awesome!!

@QAFox 2 месяца назад

Thank you! Cheers!

@harish4010 2 года назад

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

@QAFox 2 года назад

Yes, NOT != and are same

@Anyam333 10 месяцев назад

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

@VivekSingh-sl9kz 4 года назад

Good !!

@QAFox 4 года назад

Thank you

@dishasondhiya6209 2 года назад

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

@QAFox 2 года назад

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

@viveksuryanaraynan9478 2 года назад

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

@QAFox 2 года назад

Yes, NOT != and are same

@rahulk3209 2 года назад

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

@rahulk3209 2 года назад

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

@QAFox 2 года назад

@@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.