AND OR NOT operators sql
-----------------------SQL AND, OR, NOT OPERATORS------------------------------
AND: this operator displays a record if all conditions seperated by AND are true.
OR: this operator displays a record if any of the conditions seperated by OR is true.
NOT: this operator displays a record if the conditions is Not true.sql or
Used alongside WHERE to include data when either condition is true.
Example: Returns users that live in either Sheffield or Manchester.
SELECT * FROM users
WHERE city = 'Sheffield' OR 'Manchester';not in sql
(NOT) operator excluding given
For example:
Select last_name, job_id From Employees
Where "Not" job_id = 'ABC';Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
