SQLite Order By function
Translation results：
sqlite
Database; use; embedded relational database
order
英[ˈɔ:də(r )] US [ˈɔ:rdə(r)]
n. Order; command; sequence; rule, system
vt. Order; order; sort
vi. Order
by
UK[baɪ] US[baɪ]
prep.beside...;expression;due to;after
adv. pass; means to reserve or save; use; to visit briefly
SQLite Order By functionsyntax
Function:SQLite's ORDER BY clause is used to arrange data in ascending or descending order based on one or more columns.
Grammar: The basic syntax of the ORDER BY clause is as follows:
SELECT column-list
FROM table_name
[WHERE condition]
[ORDER BY column1, column2, .. columnN] [ASC | DESC];
You can use multiple columns in the ORDER BY clause. Make sure the sort column you are using is in the column list.
SQLite Order By functionexample
COMPANY 表有以下记录： ID NAME AGE ADDRESS SALARY ---------- ---------- ---------- ---------- ---------- 1 Paul 32 California 20000.0 2 Allen 25 Texas 15000.0 3 Teddy 23 Norway 20000.0 4 Mark 25 Rich-Mond 65000.0 5 David 27 Texas 85000.0 6 Kim 22 South-Hall 45000.0 7 James 24 Houston 10000.0 下面是一个实例，它会将结果按 SALARY 升序排序： sqlite> SELECT * FROM COMPANY ORDER BY SALARY ASC; 这将产生以下结果： ID NAME AGE ADDRESS SALARY ---------- ---------- ---------- ---------- ---------- 7 James 24 Houston 10000.0 2 Allen 25 Texas 15000.0 1 Paul 32 California 20000.0 3 Teddy 23 Norway 20000.0 6 Kim 22 South-Hall 45000.0 4 Mark 25 Rich-Mond 65000.0 5 David 27 Texas 85000.0 下面是一个实例，它会将结果按 NAME 和 SALARY 升序排序： sqlite> SELECT * FROM COMPANY ORDER BY NAME, SALARY ASC; 这将产生以下结果： ID NAME AGE ADDRESS SALARY ---------- ---------- ---------- ---------- ---------- 2 Allen 25 Texas 15000.0 5 David 27 Texas 85000.0 7 James 24 Houston 10000.0 6 Kim 22 South-Hall 45000.0 4 Mark 25 Rich-Mond 65000.0 1 Paul 32 California 20000.0 3 Teddy 23 Norway 20000.0 下面是一个实例，它会将结果按 NAME 降序排序： sqlite> SELECT * FROM COMPANY ORDER BY NAME DESC; 这将产生以下结果： ID NAME AGE ADDRESS SALARY ---------- ---------- ---------- ---------- ---------- 3 Teddy 23 Norway 20000.0 1 Paul 32 California 20000.0 4 Mark 25 Rich-Mond 65000.0 6 Kim 22 South-Hall 45000.0 7 James 24 Houston 10000.0 5 David 27 Texas 85000.0 2 Allen 25 Texas 15000.0