Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


    Copyright
    Preface
    Ch. 1. Using the mysql Client Program
    Ch. 2. Writing MySQL-Based Programs
    Ch. 3. Selecting Data from Tables
    Introduction
    Specifying Which Columns to Select
    Specifying Which Rows to Select
    Giving Better Names to Query Result Columns
    Using Column Aliases to Make Programs Easier to Write
    Combining Columns to Construct Composite Values
    WHERE Clauses and Column Aliases
    Debugging Comparison Expressions
    Removing Duplicate Rows
    Working with NULL Values
    Writing Comparisons Involving NULL in Programs
    Sorting a Result Set
    Using Views to Simplify Table Access
    Selecting Data from More Than One Table
    Selecting Rows from the Beginning or End of a Result Set
    Selecting Rows from the Middle of a Result Set
    Choosing Appropriate LIMIT Values
    What to Do When LIMIT Requires the Wrong Sort Order
    Calculating LIMIT Values from Expressions
    Ch. 4. Table Management
    Ch. 5. Working with Strings
    Ch. 6. Working with Dates and Times
    Ch. 7. Sorting Query Results
    Ch. 8. Generating Summaries
    Ch. 9. Obtaining and Using Metadata
    Ch. 10. Importing and Exporting Data
    Ch. 11. Generating and Using Sequences
    Ch. 12. Using Multiple Tables
    Ch. 13. Statistical Techniques
    Ch. 14. Handling Duplicates
    Ch. 15. Performing Transactions
    Ch. 16. Using Stored Routines, Triggers, and Events
    Ch. 17. Introduction to MySQL on the Web
    Ch. 18. Incorporating Query Results into Web Pages
    Ch. 19. Processing Web Input with MySQL
    Ch. 20. Using MySQL-Based Web Session Management
    Appx. A. Obtaining MySQL Software
    Appx. B. Executing Programs from the Command Line
    Appx. C. JSP and Tomcat Primer
    Appx. D. References
    Colophon
    Index
    • Create BookmarkCreate Bookmark
    • Create Note or TagCreate Note or Tag
    • DownloadDownload
    • PrintPrint
    Share this Page URL
    Help

    3.12. Sorting a Result Set

    3.12.1. Problem

    Your query results aren’t sorted the way you want.

    3.12.2. Solution

    MySQL can’t read your mind. Add an ORDER BY clause to tell it exactly how you want result rows sorted.


      

    You are currently reading a PREVIEW of this book.

                                                                                            

    Get instant access to over
    $1 million worth of books and videos.

      

    Start a Free Trial