Customizing Queries

This chapter will illustrate additional capabilities of the basic SQL commands.

 

• Data Types
• Quotes Inside Text
• Using NULL Values
• Controlling DEFAULT Values
• Column Labels
• Comments
• AND/OR Usage
• Range of Values
• LIKE Comparison
• Regular Expressions
• CASE Clause
• Distinct Rows
• Functions and Operators
• SET, SHOW, and RESET
• Summary