SQL WHERE Clause
Presentation
•
Computers
•
University
•
Practice Problem
•
Medium
Kittisay SENGTHONG
Used 4+ times
FREE Resource
6 Slides • 8 Questions
1
SQL WHERE Clause
ເງື່ອນໄຂ SQL
2
Open Ended
3
The SQL WHERE Clause
The WHERE clause is used to filter records.
The WHERE clause is used to extract only those records that fulfill a specified condition.
Note: The WHERE clause is not only used in SELECT statement, it is also used in UPDATE, DELETE statement, etc.!
4
Fill in the Blanks
5
WHERE Clause Example
The following SQL statement selects all the customers from the country "Mexico", in the "tb_Customer" table:
6
Fill in the Blanks
7
Text Fields vs. Numeric Fields
SQL requires single quotes (' ') around text values (most database systems will also allow double quotes (" ").
However, numeric fields should not be enclosed in quotes:
8
Fill in the Blanks
9
Operators in The WHERE Clause
= Equal
> Greater than
< Less than
>= Greater than or equal
<= Less than or equal
10
Fill in the Blanks
11
Operators in The WHERE Clause
BETWEEN Between a certain range
LIKE Search for a pattern
IN To specify multiple possible values for a column
12
Fill in the Blanks
13
Open Ended
14
Poll
SQL WHERE Clause
ເງື່ອນໄຂ SQL
Show answer
Auto Play
Slide 1 / 14
SLIDE
