Section 3.1. Introduction
Section 3.2. Specifying Which Columns to Display
Section 3.3. Avoiding Output Column Order Problems When Writing Programs
Section 3.4. Giving Names to Output Columns
Section 3.5. Using Column Aliases to Make Programs Easier to Write
Section 3.6. Combining Columns to Construct Composite Values
Section 3.7. Specifying Which Rows to Select
Section 3.8. WHERE Clauses and Column Aliases
Section 3.9. Displaying Comparisons to Find Out How Something Works
Section 3.10. Reversing or Negating Query Conditions
Section 3.11. Removing Duplicate Rows
Section 3.12. Working with NULL Values
Section 3.13. Negating a Condition on a Column That Contains NULL Values
Section 3.14. Writing Comparisons Involving NULL in Programs
Section 3.15. Mapping NULL Values to Other Values for Display
Section 3.16. Sorting a Result Set
Section 3.17. Selecting Records from the Beginning or End of a Result Set
Section 3.18. Pulling a Section from the Middle of a Result Set
Section 3.19. Choosing Appropriate LIMIT Values
Section 3.20. Calculating LIMIT Values from Expressions
Section 3.21. What to Do When LIMIT Requires the "Wrong" Sort Order
Section 3.22. Selecting a Result Set into an Existing Table
Section 3.23. Creating a Destination Table on the Fly from a Result Set
Section 3.24. Moving Records Between Tables Safely
Section 3.25. Creating Temporary Tables
Section 3.26. Cloning a Table Exactly
Section 3.27. Generating Unique Table Names
