and or not operators sql

Solutions on MaxInterview for and or not operators sql by the best coders in the world

showing results for - "and or not operators sql"
Ylan
07 Jul 2019
1-----------------------SQL AND, OR, NOT OPERATORS------------------------------
2AND: this operator displays a record if all conditions seperated by AND are true.
3OR: this operator displays a record if any of the conditions seperated by OR is true.
4NOT: this operator displays a record if the conditions is Not true.
Chiara
09 Jan 2019
1(NOT) operator excluding given
2For example:
3Select last_name, job_id From Employees
4Where "Not" job_id = 'ABC';
5