SQLite 排序方式
SQLite 的 ORDER BY 子句是用來基於一個或多個欄位依升序或降序順序排列資料。
語法
ORDER BY 子句的基本語法如下:
SELECT column-list
FROM table_name
[WHERE condition]
[ORDER BY column1, column2, .. columnN] [ASC | DESC];
FROM table_name
[WHERE condition]
[ORDER BY column1, column2, .. columnN] [ASC | DESC];
ID NAME ------- ---------- ---------- ----------
1 Paul 32 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 升序排序:
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 ------ ---------- ----------
7 James 24 Allen 25 Texas 15000.0
1 California 20000.0
3 Teddy 23 Norway 22 South-Hall 45000.0
4 65000.0
5 David 27 地#它會將結果依NAME 和SALARY 升序排序:
sqlite> SELECT * FROM COMPANY ORDER BY NAME, SALARY ASC;
7 James 24 Allen 25 Texas 15000.0
1 California 20000.0
3 Teddy 23 Norway 22 South-Hall 45000.0
4 65000.0
5 David 27 地#它會將結果依NAME 和SALARY 升序排序:
sqlite> SELECT * FROM COMPANY ORDER BY NAME, SALARY ASC;
這將產生以下結果:
ID NAME AGE ------ ---------- ----------
2 Allen 25 David 27 Texas 85000.0
2 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 降序排序:2 Allen 25 David 27 Texas 85000.0
2 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
這將產生以下結果:
ID NAME AGE ------ ---------- ----------
3 Teddy 23 Paul 32 California 20000.0
4 Rich- Mond 65000.0
6 Kim 22 James 24 Houston 10000.0 85000.0
2 Allen 25
#
3 Teddy 23 Paul 32 California 20000.0
4 Rich- Mond 65000.0
6 Kim 22 James 24 Houston 10000.0 85000.0
2 Allen 25
#