| 1. | Order result wiht ORDER | | |
| 2. | Use ORDER BY to list | | |
| 3. | Use two ORDER BY fields | | |
| 4. | Sorting Rows | | |
| 5. | Default sort order is ascending | | |
| 6. | To sort in reverse (descending) order | | |
| 7. | Sort on multiple columns | | |
| 8. | Sort columns in different directions | | |
| 9. | Order decending | | |
|
| 10. | Another decendingly | | |
| 11. | Order BY and Limit | | |
| 12. | Order row in select clause | | |
| 13. | Order two columns with different orders | | |
| 14. | Narrow down data with condition and order it | | |
| 15. | Simple ORDER by | | |
| 16. | Sorting Data | | |
| 17. | Use order by to sort the result | | |
| 18. | Indicate of ascend | | |
| 19. | Order by index | | |
| 20. | ORDER BY RAND | | |
| 21. | Search string with order | | |
| 22. | The lack of case sensitivity also applies to relative ordering comparisons: | | |
| 23. | Refer to the alias in the ORDER BY clause | | |
| 24. | Columns specified by positions or by aliases can be sorted in either ascending or descending order | | |
| 25. | Putting the expression directly in the ORDER BY clause: | | |
| 26. | To achieve the desired output order, display the string, but use the actual numeric size for sorting | | |
| 27. | Display the composite names, but refer to the constituent values in the ORDER BY clause: | | |
| 28. | To sort those records in calendar order, use the birthmonth and birthday columns. | | |
| 29. | To sort by product category, extract the category value and use it in the ORDER BY clause | | |
| 30. | To use the substrings for sorting, use the appropriate expressions in the ORDER BY clause. | | |
| 31. | Sorting Hostnames in Domain Order | | |
| 32. | Sorting Dotted-Quad IP Values in Numeric Order | | |
| 33. | Floating Specific Values to the Head or Tail of the Sort Order | | |
| 34. | Sorting in User-Defined Orders | | |
| 35. | Sort the column by the order in which colors occur in the rainbow. | | |
| 36. | To make the lexical ordering correspond to the numeric ordering, | | |
| 37. | Controlling Summary Display Order | | |
| 38. | Sort drivers according to who drove the most days or miles, add the appropriate ORDER BY clause | | |
| 39. | Order by sum result | | |
| 40. | To sort the result set as a whole, add an ORDER BY clause after the final SELECT statement. | | |
| 41. | Enclose a given SELECT (including its ORDER BY clause) within parentheses | | |
| 42. | The expressions display state names in lexical order within each row | | |
| 43. | Delete from the Orders table any order for the book title Where I'm Calling From. | | |
| 44. | SELECT statement includes an ORDER BY clause that sorts the result set according to two columns | | |
| 45. | Determine how many books have been ordered for authors who have more than one book listed in the Books table. | | |
| 46. | The Order in Which MySQL Processes Conditions | | |
| 47. | Return the third, fourth, and fifth records sorted in descending order on the commission field? | | |
| 48. | Explicit evaluation order | | |
| 49. | Display order number, quantity, item name, vendor and total order value of order number 2805 | | |
| 50. | Display all products - including those with no orders | | |
| 51. | Get the order number and number of items ordered where the color is not Pink and the number of items ordered i | | |
| 52. | Get players whose combination of name and initials comes before player 6 in alphabetical order. | | |
| 53. | Order by char type | | |
| 54. | order by sub string | | |
| 55. | Order by calculated value | | |
| 56. | Order by alias name | | |
| 57. | Order by one column descending and another one ascending | | |
| 58. | Order then choose the first rows | | |
| 59. | Refer to Sort Columns | | |
| 60. | Sorting Expression Results | | |
| 61. | Sort the results using the underlying column values rather than the displayed composite values | | |
| 62. | Convert the output column and sort that-but doing so affects the displayed values, possibly in an undesirable | | |
| 63. | To sort by country code, use the rightmost two characters of the id values | | |
| 64. | Sorting hostname values correctly in right-to-left fashion: | | |
| 65. | Sort by position | | |
| 66. | Sort direction | | |
| 67. | display all data in "hers" and "his" sorted by id | | |
| 68. | Sorting Subsets of a Table | | |
| 69. | Displaying One Set of Values While Sorting by Another | | |