Filtering Data Flashcards

1
Q

WHERE position

A

The WHERE clause is specified right after the table name (the FROM clause).

WHERE must go BEFORE ORDER BY

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

WHERE clause operators

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Text indicator

A

‘’

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

NULL

A

no value – WHERE prod_price IS NULL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly