Section 3.0. Introduction Recipe 3.1. Specifying Which Columns to Select Recipe 3.2. Specifying Which Rows to Select Recipe 3.3. Giving Better Names to Query Result Columns Recipe 3.4. Using Column Aliases to Make Programs Easier to Write Recipe 3.5. Combining Columns to Construct Composite Values Recipe 3.6. WHERE Clauses and Column Aliases Recipe 3.7. Debugging Comparison Expressions Recipe 3.8. Removing Duplicate Rows Recipe 3.9. Working with NULL Values Recipe 3.10. Writing Comparisons Involving NULL in Programs Recipe 3.11. Sorting a Result Set Recipe 3.12. Using Views to Simplify Table Access Recipe 3.13. Selecting Data from More Than One Table Recipe 3.14. Selecting Rows from the Beginning or End of a Result Set Recipe 3.15. Selecting Rows from the Middle of a Result Set Recipe 3.16. Choosing Appropriate LIMIT Values Recipe 3.17. What to Do When LIMIT Requires the Wrong Sort Order Recipe 3.18. Calculating LIMIT Values from Expressions |