1 / 3

Mastering SQL WHERE and Logical Operators

Learn how to use WHERE clause in SQL to filter records and combine it with AND, OR, and NOT operators to refine your queries effectively.

paki-irwin
Télécharger la présentation

Mastering SQL WHERE and Logical Operators

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Lesson 15 SQL AND, OR and NOT Operators Trainer: Bach Ngoc Toan– TEDU Website: http://tedu.com.vn

  2. SQL WHERE • A WHERE clause in SQL is a data manipulation language statement. • Actually. it filters the records. It returns only those queries which fulfill the specific conditions. • WHERE clause is used in SELECT, UPDATE, DELETE statement etc. SELECT column1, column 2, ... column n   FROM    table_name   WHERE [conditions]  

  3. SQL AND, OR and NOT Operators • The WHERE clause can be combined with AND, OR, and NOT operators. • The AND and OR operators are used to filter records based on more than one condition: • The AND operator displays a record if all the conditions separated by AND is TRUE. • The OR operator displays a record if any of the conditions separated by OR is TRUE. • The NOT operator displays a record if the condition(s) is NOT TRUE.

More Related