Sunday, October 25, 2009

Chapter 6. Sorting Query Results




I l@ve RuBoard










Chapter 6. Sorting Query Results





    Section 6.1. 
    Introduction



    Section 6.2. 
    Using ORDER BY to Sort Query Results



    Section 6.3. 
    Sorting Subsets of a Table



    Section 6.4. 
    Sorting Expression Results



    Section 6.5. 
    Displaying One Set of Values While Sorting by Another



    Section 6.6. 
    Sorting and NULL Values



    Section 6.7. 
    Controlling Case Sensitivity of String Sorts



    Section 6.8. 
    Date-Based Sorting



    Section 6.9. 
    Sorting by Calendar Day



    Section 6.10. 
    Sorting by Day of Week



    Section 6.11. 
    Sorting by Time of Day



    Section 6.12. 
    Sorting Using Substrings of Column Values



    Section 6.13. 
    Sorting by Fixed-Length Substrings



    Section 6.14. 
    Sorting by Variable-Length Substrings



    Section 6.15. 
    Sorting Hostnames in Domain Order



    Section 6.16. 
    Sorting Dotted-Quad IP Values in Numeric Order



    Section 6.17. 
    Floating Specific Values to the Head or Tail of the Sort Order



    Section 6.18. 
    Sorting in User-Defined Orders



    Section 6.19. 
    Sorting ENUM Values







I l@ve RuBoard



No comments: