10 Query Result sorting

1. Sort the specified columnssingle-column sorting features:(1) Sorting basis(2) Sorting method: Ascending, Descending (Asc/desc)SELECT col_list from table _nameORDER by ordered_by_list [Asc/desc] Example: Query all the score information in the score table numbered 1 and sort in ascending order of fractions SELECT * FROM scoresWHERE GNO = 1ORDER by score ASC 2. Multi-column sortingmulti-column sorting features:(1) Sorting basis(2) Sorting method(3) Priority levelSELECT col_list from table _nameORDER by ordered_by_list1 [Asc/desc],ordered_by_list2 [Asc/desc] ... Example: Query the score bar for all information and sort by the game number ascending and descending order of fractions SELECT * FROM scoresWHERE GNO = 1ORDER by gno ASC, score DESC Note: High priority in front

10 Query Result sorting