Database Management Concepts

Compound Conditions, Computed Fields, Using Special Operators

Transcript

1. Database Management Concepts 49941131 Jia-Huei, Ren
2. Topic • Compound Conditions • Computed Fields • Using Special Operators
3. Topic • Compound Conditions • Computed Fields • Using Special Operators
4. Topic • Compound Conditions • Computed Fields • Using Special Operators
5. Compound Conditions 5
6. AND vs. OR
7. NOT Reverses the truth or falsity of the original condition
8. BETWEEN Value must be between the listed numbers
9. Compound Conditions (continued) FIGURE 3-16: Query results FIGURE 3-15: Compound condition that uses the AND operator 9
10. Compound Conditions (continued) FIGURE 3-18: Query results FIGURE 3-17: Compound condition that uses the OR operator 10
11. Computed Fields Computed field or calculated field Field whose values you derive from existing fields Can involve: Addition (+) Subtraction (-) Multiplication (*) Division (/) 11
12. Computed Fields (continued) FIGURE 3-26: Query results FIGURE 3-25: SQL query with a computed field and condition 12
13. Using Special Operators
14. Wildcards in Access SQL
15. Asterisk : * any collection of characters
16. Question mark : ? any individual character
17. Wildcards in Access SQL
18. Same?
19. Same?
20. Percent sign : % any collection of characters
21. Underscore : _ any individual character
22. To use a wildcard, include the LIKE operator in the WHERE clause
23. IN operator provides a concise way of phrasing certain conditions
24. Using Special Operators (LIKE and IN) (continued) FIGURE 3-28: Query results FIGURE 3-27: SQL query with a LIKE operator 24
25. Using Special Operators (LIKE and IN) (continued) FIGURE 3-30: Query results FIGURE 3-29: SQL query with an IN operator 25
26. Thanks