SQL 的五十道練習¶

排序查詢結果

數據交點 | 郭耀仁 yaojenkuo@datainpoint.com

這個章節要學起來的 SQL 保留字¶

  • ORDER BY
  • ASC
  • DESC

以 ORDER BY 排序查詢結果¶

截至目前，我們所獲得的查詢結果是依據觀測值在資料表中所存放的順序呈現¶

加入 ORDER BY 能夠以指定變數的大小來排序查詢結果¶

SELECT column_names
  FROM table_name
 ORDER BY column_names;

arrange

排序方式有兩種：¶

  1. 遞增（或稱升冪）排序。
  2. 遞減（或稱降冪）排序。

預設的排序方式為遞增¶

In [5]:
SELECT *
  FROM movies
 ORDER BY rating;
Out[5]:
id title release_year rating director runtime
152 Three Billboards Outside Ebbing, Missouri 2017 8.1 Martin McDonagh 115
154 Chinatown 1974 8.1 Roman Polanski 130
156 No Country for Old Men 2007 8.1 Ethan Coen 122
158 Inside Out 2015 8.1 Pete Docter 95
159 The Thing 1982 8.1 John Carpenter 109
160 The Elephant Man 1980 8.1 David Lynch 124
162 The Sixth Sense 1999 8.1 M. Night Shyamalan 107
164 Jurassic Park 1993 8.1 Steven Spielberg 127
166 Trainspotting 1996 8.1 Danny Boyle 93
168 The Truman Show 1998 8.1 Peter Weir 103
169 Gone with the Wind 1939 8.1 Victor Fleming 238
170 Finding Nemo 2003 8.1 Andrew Stanton 100
173 Memories of Murder 2003 8.1 Bong Joon Ho 132
174 Kill Bill: Vol. 1 2003 8.1 Quentin Tarantino 111
175 Blade Runner 1982 8.1 Ridley Scott 117
176 The Bridge on the River Kwai 1957 8.1 David Lean 161
177 Fargo 1996 8.1 Joel Coen 98
178 Wild Tales 2014 8.1 Damián Szifron 122
179 Room 2015 8.1 Lenny Abrahamson 118
181 The Third Man 1949 8.1 Carol Reed 93
182 Gran Torino 2008 8.1 Clint Eastwood 116
183 On the Waterfront 1954 8.1 Elia Kazan 108
184 The Deer Hunter 1978 8.1 Michael Cimino 183
185 In the Name of the Father 1993 8.1 Jim Sheridan 133
186 Mary and Max 2009 8.1 Adam Elliot 92
187 Before Sunrise 1995 8.1 Richard Linklater 101
188 The Grand Budapest Hotel 2014 8.1 Wes Anderson 99
189 Catch Me If You Can 2002 8.1 Steven Spielberg 141
190 Gone Girl 2014 8.1 David Fincher 149
191 Hacksaw Ridge 2016 8.1 Mel Gibson 139
192 Prisoners 2013 8.1 Denis Villeneuve 153
193 Persona 1966 8.1 Ingmar Bergman 83
196 The Big Lebowski 1998 8.1 Joel Coen 117
198 Barry Lyndon 1975 8.1 Stanley Kubrick 185
199 The General 1926 8.1 Clyde Bruckman 67
200 How to Train Your Dragon 2010 8.1 Dean DeBlois 98
201 Ford v Ferrari 2019 8.1 James Mangold 152
202 12 Years a Slave 2013 8.1 Steve McQueen 134
205 Mr. Smith Goes to Washington 1939 8.1 Frank Capra 129
206 Mad Max: Fury Road 2015 8.1 George Miller 120
208 Dead Poets Society 1989 8.1 Peter Weir 128
209 Million Dollar Baby 2004 8.1 Clint Eastwood 132
210 Harry Potter and the Deathly Hallows: Part 2 2011 8.1 David Yates 130
211 Stand by Me 1986 8.1 Rob Reiner 89
212 Network 1976 8.1 Sidney Lumet 121
213 Ben-Hur 1959 8.1 William Wyler 212
214 Hachi: A Dog's Tale 2009 8.1 Lasse Hallström 93
215 The Handmaiden 2016 8.1 Chan-wook Park 145
216 Cool Hand Luke 1967 8.1 Stuart Rosenberg 127
217 Logan 2017 8.1 James Mangold 137
218 Platoon 1986 8.1 Oliver Stone 120
219 The Wages of Fear 1953 8.1 Henri-Georges Clouzot 131
220 Into the Wild 2007 8.1 Sean Penn 148
221 Rush 2013 8.1 Ron Howard 123
222 La Haine 1995 8.1 Mathieu Kassovitz 98
223 Monty Python's Life of Brian 1979 8.1 Terry Jones 94
224 The 400 Blows 1959 8.1 François Truffaut 99
225 The Passion of Joan of Arc 1928 8.1 Carl Theodor Dreyer 114
226 Spotlight 2015 8.1 Tom McCarthy 129
228 Hotel Rwanda 2004 8.1 Terry George 121
230 Amores Perros 2000 8.1 Alejandro G. Iñárritu 154
231 Soul 2020 8.1 Pete Docter 100
232 Andrei Rublev 1966 8.1 Andrei Tarkovsky 205
233 Monsters, Inc. 2001 8.1 Pete Docter 92
234 Rocky 1976 8.1 John G. Avildsen 120
235 Nausicaä of the Valley of the Wind 1984 8.1 Hayao Miyazaki 117
236 Rebecca 1940 8.1 Alfred Hitchcock 130
238 Before Sunset 2004 8.1 Richard Linklater 80
239 In the Mood for Love 2000 8.1 Kar-Wai Wong 98
240 Rififi 1955 8.1 Jules Dassin 118
242 Paris, Texas 1984 8.1 Wim Wenders 145
244 Portrait of a Lady on Fire 2019 8.1 Céline Sciamma 122
245 It Happened One Night 1934 8.1 Frank Capra 105
246 Neon Genesis Evangelion: The End of Evangelion 1997 8.1 Hideaki Anno 87
109 Taxi Driver 1976 8.2 Martin Scorsese 114
112 Toy Story 3 2010 8.2 Lee Unkrich 103
118 For a Few Dollars More 1965 8.2 Sergio Leone 132
120 To Kill a Mockingbird 1962 8.2 Robert Mulligan 129
121 Up 2009 8.2 Pete Docter 96
122 Indiana Jones and the Last Crusade 1989 8.2 Steven Spielberg 127
123 Heat 1995 8.2 Michael Mann 170
124 L.A. Confidential 1997 8.2 Curtis Hanson 138
125 Green Book 2018 8.2 Peter Farrelly 130
126 Die Hard 1988 8.2 John McTiernan 132
127 Batman Begins 2005 8.2 Christopher Nolan 140
128 Yojimbo 1961 8.2 Akira Kurosawa 110
129 Monty Python and the Holy Grail 1975 8.2 Terry Gilliam 91
130 Rashomon 1950 8.2 Akira Kurosawa 88
131 Downfall 2004 8.2 Oliver Hirschbiegel 156
133 Ran 1985 8.2 Akira Kurosawa 162
134 Unforgiven 1992 8.2 Clint Eastwood 130
135 Some Like It Hot 1959 8.2 Billy Wilder 121
136 Howl's Moving Castle 2004 8.2 Hayao Miyazaki 119
137 All About Eve 1950 8.2 Joseph L. Mankiewicz 138
138 Casino 1995 8.2 Martin Scorsese 178
139 A Beautiful Mind 2001 8.2 Ron Howard 135
140 The Wolf of Wall Street 2013 8.2 Martin Scorsese 180
141 The Great Escape 1963 8.2 John Sturges 172
142 Pan's Labyrinth 2006 8.2 Guillermo del Toro 118
143 There Will Be Blood 2007 8.2 Paul Thomas Anderson 158
144 The Secret in Their Eyes 2009 8.2 Juan José Campanella 129
145 Lock, Stock and Two Smoking Barrels 1998 8.2 Guy Ritchie 107
146 Judgment at Nuremberg 1961 8.2 Stanley Kramer 179
147 Raging Bull 1980 8.2 Martin Scorsese 129
148 My Neighbor Totoro 1988 8.2 Hayao Miyazaki 86
149 The Treasure of the Sierra Madre 1948 8.2 John Huston 126
150 Dial M for Murder 1954 8.2 Alfred Hitchcock 105
151 Shutter Island 2010 8.2 Martin Scorsese 138
153 The Gold Rush 1925 8.2 Charles Chaplin 95
157 V for Vendetta 2005 8.2 James McTeigue 132
161 The Seventh Seal 1957 8.2 Ingmar Bergman 96
163 Warrior 2011 8.2 Gavin O'Connor 140
165 Klaus 2019 8.2 Sergio Pablos 96
171 Stalker 1979 8.2 Andrei Tarkovsky 162
172 Wild Strawberries 1957 8.2 Ingmar Bergman 91
180 Tokyo Story 1953 8.2 Yasujirô Ozu 136
195 Sherlock Jr. 1924 8.2 Buster Keaton 45
197 To Be or Not to Be 1942 8.2 Ernst Lubitsch 99
203 The Bandit 1996 8.2 Yavuz Turgul 128
204 Autumn Sonata 1978 8.2 Ingmar Bergman 99
229 Gangs of Wasseypur 2012 8.2 Anurag Kashyap 321
237 Time of the Gypsies 1988 8.2 Emir Kusturica 142
241 Rang De Basanti 2006 8.2 Rakeysh Omprakash Mehra 167
247 7 Kogustaki Mucize 2019 8.2 Mehmet Ada Öztekin 132
248 Tangerines 2013 8.2 Zaza Urushadze 87
249 Drishyam 2015 8.2 Nishikant Kamat 163
250 Swades 2004 8.2 Ashutosh Gowariker 189
74 Aliens 1986 8.3 James Cameron 137
78 American Beauty 1999 8.3 Sam Mendes 122
79 Braveheart 1995 8.3 Mel Gibson 178
81 Das Boot 1981 8.3 Wolfgang Petersen 149
82 Toy Story 1995 8.3 John Lasseter 81
84 Amadeus 1984 8.3 Milos Forman 160
85 Inglourious Basterds 2009 8.3 Quentin Tarantino 153
86 Good Will Hunting 1997 8.3 Gus Van Sant 126
87 Star Wars: Episode VI - Return of the Jedi 1983 8.3 Richard Marquand 131
89 Reservoir Dogs 1992 8.3 Quentin Tarantino 99
90 2001: A Space Odyssey 1968 8.3 Stanley Kubrick 149
91 Requiem for a Dream 2000 8.3 Darren Aronofsky 102
92 The Hunt 2012 8.3 Thomas Vinterberg 115
93 Vertigo 1958 8.3 Alfred Hitchcock 128
94 M 1931 8.3 Fritz Lang 99
95 Eternal Sunshine of the Spotless Mind 2004 8.3 Michel Gondry 108
96 Citizen Kane 1941 8.3 Orson Welles 119
98 Singin' in the Rain 1952 8.3 Stanley Donen 103
99 The Kid 1921 8.3 Charles Chaplin 68
100 Bicycle Thieves 1948 8.3 Vittorio De Sica 89
101 Full Metal Jacket 1987 8.3 Stanley Kubrick 116
102 Come and See 1985 8.3 Elem Klimov 142
103 Snatch 2000 8.3 Guy Ritchie 102
104 Ikiru 1952 8.3 Akira Kurosawa 143
105 North by Northwest 1959 8.3 Alfred Hitchcock 136
106 A Clockwork Orange 1971 8.3 Stanley Kubrick 136
107 Scarface 1983 8.3 Brian De Palma 170
108 1917 2019 8.3 Sam Mendes 119
110 Incendies 2010 8.3 Denis Villeneuve 131
111 A Separation 2011 8.3 Asghar Farhadi 123
113 The Sting 1973 8.3 George Roy Hill 129
114 Lawrence of Arabia 1962 8.3 David Lean 228
115 Amélie 2001 8.3 Jean-Pierre Jeunet 122
116 Metropolis 1927 8.3 Fritz Lang 153
117 The Apartment 1960 8.3 Billy Wilder 125
119 Double Indemnity 1944 8.3 Billy Wilder 107
132 Children of Heaven 1997 8.3 Majid Majidi 89
155 My Father and My Son 2005 8.3 Çagan Irmak 112
167 Zack Snyder's Justice League 2021 8.3 Zack Snyder 242
194 Andhadhun 2018 8.3 Sriram Raghavan 139
207 Anand 1971 8.3 Hrishikesh Mukherjee 122
51 Rear Window 1954 8.4 Alfred Hitchcock 112
52 Alien 1979 8.4 Ridley Scott 117
53 Apocalypse Now 1979 8.4 Francis Ford Coppola 147
54 Memento 2000 8.4 Christopher Nolan 113
55 The Great Dictator 1940 8.4 Charles Chaplin 125
56 Indiana Jones and the Raiders of the Lost Ark 1981 8.4 Steven Spielberg 115
57 Django Unchained 2012 8.4 Quentin Tarantino 165
58 The Lives of Others 2006 8.4 Florian Henckel von Donnersmarck 137
60 Paths of Glory 1957 8.4 Stanley Kubrick 88
61 WALL·E 2008 8.4 Andrew Stanton 98
62 Joker 2019 8.4 Todd Phillips 122
63 The Shining 1980 8.4 Stanley Kubrick 146
64 Avengers: Infinity War 2018 8.4 Anthony Russo 149
65 Sunset Blvd. 1950 8.4 Billy Wilder 110
66 Witness for the Prosecution 1957 8.4 Billy Wilder 116
67 Oldboy 2003 8.4 Chan-wook Park 120
68 Spider-Man: Into the Spider-Verse 2018 8.4 Bob Persichetti 117
69 Princess Mononoke 1997 8.4 Hayao Miyazaki 134
70 Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb 1964 8.4 Stanley Kubrick 95
71 The Dark Knight Rises 2012 8.4 Christopher Nolan 164
72 Once Upon a Time in America 1984 8.4 Sergio Leone 229
73 Your Name. 2016 8.4 Makoto Shinkai 106
75 Coco 2017 8.4 Lee Unkrich 105
76 Avengers: Endgame 2019 8.4 Anthony Russo 181
77 Capernaum 2018 8.4 Nadine Labaki 126
80 High and Low 1963 8.4 Akira Kurosawa 143
83 3 Idiots 2009 8.4 Rajkumar Hirani 170
88 Like Stars on Earth 2007 8.4 Aamir Khan 165
97 Dangal 2016 8.4 Nitesh Tiwari 161
243 Drishyam 2013 8.4 Jeethu Joseph 160
31 Léon: The Professional 1994 8.5 Luc Besson 110
33 The Usual Suspects 1995 8.5 Bryan Singer 106
34 The Lion King 1994 8.5 Roger Allers 88
35 The Pianist 2002 8.5 Roman Polanski 150
36 Terminator 2: Judgment Day 1991 8.5 James Cameron 137
37 Back to the Future 1985 8.5 Robert Zemeckis 116
38 American History X 1998 8.5 Tony Kaye 119
39 Modern Times 1936 8.5 Charles Chaplin 87
40 Gladiator 2000 8.5 Ridley Scott 155
41 Psycho 1960 8.5 Alfred Hitchcock 109
42 The Departed 2006 8.5 Martin Scorsese 151
43 City Lights 1931 8.5 Charles Chaplin 87
44 The Intouchables 2011 8.5 Olivier Nakache 112
45 Whiplash 2014 8.5 Damien Chazelle 106
46 Grave of the Fireflies 1988 8.5 Isao Takahata 89
47 The Prestige 2006 8.5 Christopher Nolan 130
48 Once Upon a Time in the West 1968 8.5 Sergio Leone 165
49 Casablanca 1942 8.5 Michael Curtiz 102
50 Cinema Paradiso 1988 8.5 Giuseppe Tornatore 155
59 Hamilton 2020 8.5 Thomas Kail 160
227 Raatchasan 2018 8.5 Ram Kumar 170
19 Seven Samurai 1954 8.6 Akira Kurosawa 207
20 Se7en 1995 8.6 David Fincher 127
21 Life Is Beautiful 1997 8.6 Roberto Benigni 116
22 City of God 2002 8.6 Fernando Meirelles 130
23 The Silence of the Lambs 1991 8.6 Jonathan Demme 118
24 It's a Wonderful Life 1946 8.6 Frank Capra 130
25 Star Wars: Episode IV - A New Hope 1977 8.6 George Lucas 121
26 Saving Private Ryan 1998 8.6 Steven Spielberg 169
27 The Green Mile 1999 8.6 Frank Darabont 189
28 Spirited Away 2001 8.6 Hayao Miyazaki 125
29 Interstellar 2014 8.6 Christopher Nolan 169
30 Parasite 2019 8.6 Bong Joon Ho 132
32 Hara-Kiri 1962 8.6 Masaki Kobayashi 133
14 The Lord of the Rings: The Two Towers 2002 8.7 Peter Jackson 179
15 Star Wars: Episode V - The Empire Strikes Back 1980 8.7 Irvin Kershner 124
16 The Matrix 1999 8.7 Lana Wachowski 136
17 Goodfellas 1990 8.7 Martin Scorsese 146
18 One Flew Over the Cuckoo's Nest 1975 8.7 Milos Forman 133
9 The Good, the Bad and the Ugly 1966 8.8 Sergio Leone 178
10 The Lord of the Rings: The Fellowship of the Ring 2001 8.8 Peter Jackson 178
11 Fight Club 1999 8.8 David Fincher 139
12 Forrest Gump 1994 8.8 Robert Zemeckis 142
13 Inception 2010 8.8 Christopher Nolan 148
6 Schindler's List 1993 8.9 Steven Spielberg 195
7 The Lord of the Rings: The Return of the King 2003 8.9 Peter Jackson 201
8 Pulp Fiction 1994 8.9 Quentin Tarantino 154
3 The Godfather: Part II 1974 9 Francis Ford Coppola 202
4 The Dark Knight 2008 9 Christopher Nolan 152
5 12 Angry Men 1957 9 Sidney Lumet 96
2 The Godfather 1972 9.2 Francis Ford Coppola 175
1 The Shawshank Redemption 1994 9.3 Frank Darabont 142
250 rows in set (0.01 sec)

如果想「明確」表達遞增排序，可以加上保留字 ASC（Ascending），但這麼做會顯得有些多餘¶

In [13]:
SELECT *
  FROM movies
 ORDER BY rating ASC;
Out[13]:
id title release_year rating director runtime
152 Three Billboards Outside Ebbing, Missouri 2017 8.1 Martin McDonagh 115
154 Chinatown 1974 8.1 Roman Polanski 130
156 No Country for Old Men 2007 8.1 Ethan Coen 122
158 Inside Out 2015 8.1 Pete Docter 95
159 The Thing 1982 8.1 John Carpenter 109
160 The Elephant Man 1980 8.1 David Lynch 124
162 The Sixth Sense 1999 8.1 M. Night Shyamalan 107
164 Jurassic Park 1993 8.1 Steven Spielberg 127
166 Trainspotting 1996 8.1 Danny Boyle 93
168 The Truman Show 1998 8.1 Peter Weir 103
169 Gone with the Wind 1939 8.1 Victor Fleming 238
170 Finding Nemo 2003 8.1 Andrew Stanton 100
173 Memories of Murder 2003 8.1 Bong Joon Ho 132
174 Kill Bill: Vol. 1 2003 8.1 Quentin Tarantino 111
175 Blade Runner 1982 8.1 Ridley Scott 117
176 The Bridge on the River Kwai 1957 8.1 David Lean 161
177 Fargo 1996 8.1 Joel Coen 98
178 Wild Tales 2014 8.1 Damián Szifron 122
179 Room 2015 8.1 Lenny Abrahamson 118
181 The Third Man 1949 8.1 Carol Reed 93
182 Gran Torino 2008 8.1 Clint Eastwood 116
183 On the Waterfront 1954 8.1 Elia Kazan 108
184 The Deer Hunter 1978 8.1 Michael Cimino 183
185 In the Name of the Father 1993 8.1 Jim Sheridan 133
186 Mary and Max 2009 8.1 Adam Elliot 92
187 Before Sunrise 1995 8.1 Richard Linklater 101
188 The Grand Budapest Hotel 2014 8.1 Wes Anderson 99
189 Catch Me If You Can 2002 8.1 Steven Spielberg 141
190 Gone Girl 2014 8.1 David Fincher 149
191 Hacksaw Ridge 2016 8.1 Mel Gibson 139
192 Prisoners 2013 8.1 Denis Villeneuve 153
193 Persona 1966 8.1 Ingmar Bergman 83
196 The Big Lebowski 1998 8.1 Joel Coen 117
198 Barry Lyndon 1975 8.1 Stanley Kubrick 185
199 The General 1926 8.1 Clyde Bruckman 67
200 How to Train Your Dragon 2010 8.1 Dean DeBlois 98
201 Ford v Ferrari 2019 8.1 James Mangold 152
202 12 Years a Slave 2013 8.1 Steve McQueen 134
205 Mr. Smith Goes to Washington 1939 8.1 Frank Capra 129
206 Mad Max: Fury Road 2015 8.1 George Miller 120
208 Dead Poets Society 1989 8.1 Peter Weir 128
209 Million Dollar Baby 2004 8.1 Clint Eastwood 132
210 Harry Potter and the Deathly Hallows: Part 2 2011 8.1 David Yates 130
211 Stand by Me 1986 8.1 Rob Reiner 89
212 Network 1976 8.1 Sidney Lumet 121
213 Ben-Hur 1959 8.1 William Wyler 212
214 Hachi: A Dog's Tale 2009 8.1 Lasse Hallström 93
215 The Handmaiden 2016 8.1 Chan-wook Park 145
216 Cool Hand Luke 1967 8.1 Stuart Rosenberg 127
217 Logan 2017 8.1 James Mangold 137
218 Platoon 1986 8.1 Oliver Stone 120
219 The Wages of Fear 1953 8.1 Henri-Georges Clouzot 131
220 Into the Wild 2007 8.1 Sean Penn 148
221 Rush 2013 8.1 Ron Howard 123
222 La Haine 1995 8.1 Mathieu Kassovitz 98
223 Monty Python's Life of Brian 1979 8.1 Terry Jones 94
224 The 400 Blows 1959 8.1 François Truffaut 99
225 The Passion of Joan of Arc 1928 8.1 Carl Theodor Dreyer 114
226 Spotlight 2015 8.1 Tom McCarthy 129
228 Hotel Rwanda 2004 8.1 Terry George 121
230 Amores Perros 2000 8.1 Alejandro G. Iñárritu 154
231 Soul 2020 8.1 Pete Docter 100
232 Andrei Rublev 1966 8.1 Andrei Tarkovsky 205
233 Monsters, Inc. 2001 8.1 Pete Docter 92
234 Rocky 1976 8.1 John G. Avildsen 120
235 Nausicaä of the Valley of the Wind 1984 8.1 Hayao Miyazaki 117
236 Rebecca 1940 8.1 Alfred Hitchcock 130
238 Before Sunset 2004 8.1 Richard Linklater 80
239 In the Mood for Love 2000 8.1 Kar-Wai Wong 98
240 Rififi 1955 8.1 Jules Dassin 118
242 Paris, Texas 1984 8.1 Wim Wenders 145
244 Portrait of a Lady on Fire 2019 8.1 Céline Sciamma 122
245 It Happened One Night 1934 8.1 Frank Capra 105
246 Neon Genesis Evangelion: The End of Evangelion 1997 8.1 Hideaki Anno 87
109 Taxi Driver 1976 8.2 Martin Scorsese 114
112 Toy Story 3 2010 8.2 Lee Unkrich 103
118 For a Few Dollars More 1965 8.2 Sergio Leone 132
120 To Kill a Mockingbird 1962 8.2 Robert Mulligan 129
121 Up 2009 8.2 Pete Docter 96
122 Indiana Jones and the Last Crusade 1989 8.2 Steven Spielberg 127
123 Heat 1995 8.2 Michael Mann 170
124 L.A. Confidential 1997 8.2 Curtis Hanson 138
125 Green Book 2018 8.2 Peter Farrelly 130
126 Die Hard 1988 8.2 John McTiernan 132
127 Batman Begins 2005 8.2 Christopher Nolan 140
128 Yojimbo 1961 8.2 Akira Kurosawa 110
129 Monty Python and the Holy Grail 1975 8.2 Terry Gilliam 91
130 Rashomon 1950 8.2 Akira Kurosawa 88
131 Downfall 2004 8.2 Oliver Hirschbiegel 156
133 Ran 1985 8.2 Akira Kurosawa 162
134 Unforgiven 1992 8.2 Clint Eastwood 130
135 Some Like It Hot 1959 8.2 Billy Wilder 121
136 Howl's Moving Castle 2004 8.2 Hayao Miyazaki 119
137 All About Eve 1950 8.2 Joseph L. Mankiewicz 138
138 Casino 1995 8.2 Martin Scorsese 178
139 A Beautiful Mind 2001 8.2 Ron Howard 135
140 The Wolf of Wall Street 2013 8.2 Martin Scorsese 180
141 The Great Escape 1963 8.2 John Sturges 172
142 Pan's Labyrinth 2006 8.2 Guillermo del Toro 118
143 There Will Be Blood 2007 8.2 Paul Thomas Anderson 158
144 The Secret in Their Eyes 2009 8.2 Juan José Campanella 129
145 Lock, Stock and Two Smoking Barrels 1998 8.2 Guy Ritchie 107
146 Judgment at Nuremberg 1961 8.2 Stanley Kramer 179
147 Raging Bull 1980 8.2 Martin Scorsese 129
148 My Neighbor Totoro 1988 8.2 Hayao Miyazaki 86
149 The Treasure of the Sierra Madre 1948 8.2 John Huston 126
150 Dial M for Murder 1954 8.2 Alfred Hitchcock 105
151 Shutter Island 2010 8.2 Martin Scorsese 138
153 The Gold Rush 1925 8.2 Charles Chaplin 95
157 V for Vendetta 2005 8.2 James McTeigue 132
161 The Seventh Seal 1957 8.2 Ingmar Bergman 96
163 Warrior 2011 8.2 Gavin O'Connor 140
165 Klaus 2019 8.2 Sergio Pablos 96
171 Stalker 1979 8.2 Andrei Tarkovsky 162
172 Wild Strawberries 1957 8.2 Ingmar Bergman 91
180 Tokyo Story 1953 8.2 Yasujirô Ozu 136
195 Sherlock Jr. 1924 8.2 Buster Keaton 45
197 To Be or Not to Be 1942 8.2 Ernst Lubitsch 99
203 The Bandit 1996 8.2 Yavuz Turgul 128
204 Autumn Sonata 1978 8.2 Ingmar Bergman 99
229 Gangs of Wasseypur 2012 8.2 Anurag Kashyap 321
237 Time of the Gypsies 1988 8.2 Emir Kusturica 142
241 Rang De Basanti 2006 8.2 Rakeysh Omprakash Mehra 167
247 7 Kogustaki Mucize 2019 8.2 Mehmet Ada Öztekin 132
248 Tangerines 2013 8.2 Zaza Urushadze 87
249 Drishyam 2015 8.2 Nishikant Kamat 163
250 Swades 2004 8.2 Ashutosh Gowariker 189
74 Aliens 1986 8.3 James Cameron 137
78 American Beauty 1999 8.3 Sam Mendes 122
79 Braveheart 1995 8.3 Mel Gibson 178
81 Das Boot 1981 8.3 Wolfgang Petersen 149
82 Toy Story 1995 8.3 John Lasseter 81
84 Amadeus 1984 8.3 Milos Forman 160
85 Inglourious Basterds 2009 8.3 Quentin Tarantino 153
86 Good Will Hunting 1997 8.3 Gus Van Sant 126
87 Star Wars: Episode VI - Return of the Jedi 1983 8.3 Richard Marquand 131
89 Reservoir Dogs 1992 8.3 Quentin Tarantino 99
90 2001: A Space Odyssey 1968 8.3 Stanley Kubrick 149
91 Requiem for a Dream 2000 8.3 Darren Aronofsky 102
92 The Hunt 2012 8.3 Thomas Vinterberg 115
93 Vertigo 1958 8.3 Alfred Hitchcock 128
94 M 1931 8.3 Fritz Lang 99
95 Eternal Sunshine of the Spotless Mind 2004 8.3 Michel Gondry 108
96 Citizen Kane 1941 8.3 Orson Welles 119
98 Singin' in the Rain 1952 8.3 Stanley Donen 103
99 The Kid 1921 8.3 Charles Chaplin 68
100 Bicycle Thieves 1948 8.3 Vittorio De Sica 89
101 Full Metal Jacket 1987 8.3 Stanley Kubrick 116
102 Come and See 1985 8.3 Elem Klimov 142
103 Snatch 2000 8.3 Guy Ritchie 102
104 Ikiru 1952 8.3 Akira Kurosawa 143
105 North by Northwest 1959 8.3 Alfred Hitchcock 136
106 A Clockwork Orange 1971 8.3 Stanley Kubrick 136
107 Scarface 1983 8.3 Brian De Palma 170
108 1917 2019 8.3 Sam Mendes 119
110 Incendies 2010 8.3 Denis Villeneuve 131
111 A Separation 2011 8.3 Asghar Farhadi 123
113 The Sting 1973 8.3 George Roy Hill 129
114 Lawrence of Arabia 1962 8.3 David Lean 228
115 Amélie 2001 8.3 Jean-Pierre Jeunet 122
116 Metropolis 1927 8.3 Fritz Lang 153
117 The Apartment 1960 8.3 Billy Wilder 125
119 Double Indemnity 1944 8.3 Billy Wilder 107
132 Children of Heaven 1997 8.3 Majid Majidi 89
155 My Father and My Son 2005 8.3 Çagan Irmak 112
167 Zack Snyder's Justice League 2021 8.3 Zack Snyder 242
194 Andhadhun 2018 8.3 Sriram Raghavan 139
207 Anand 1971 8.3 Hrishikesh Mukherjee 122
51 Rear Window 1954 8.4 Alfred Hitchcock 112
52 Alien 1979 8.4 Ridley Scott 117
53 Apocalypse Now 1979 8.4 Francis Ford Coppola 147
54 Memento 2000 8.4 Christopher Nolan 113
55 The Great Dictator 1940 8.4 Charles Chaplin 125
56 Indiana Jones and the Raiders of the Lost Ark 1981 8.4 Steven Spielberg 115
57 Django Unchained 2012 8.4 Quentin Tarantino 165
58 The Lives of Others 2006 8.4 Florian Henckel von Donnersmarck 137
60 Paths of Glory 1957 8.4 Stanley Kubrick 88
61 WALL·E 2008 8.4 Andrew Stanton 98
62 Joker 2019 8.4 Todd Phillips 122
63 The Shining 1980 8.4 Stanley Kubrick 146
64 Avengers: Infinity War 2018 8.4 Anthony Russo 149
65 Sunset Blvd. 1950 8.4 Billy Wilder 110
66 Witness for the Prosecution 1957 8.4 Billy Wilder 116
67 Oldboy 2003 8.4 Chan-wook Park 120
68 Spider-Man: Into the Spider-Verse 2018 8.4 Bob Persichetti 117
69 Princess Mononoke 1997 8.4 Hayao Miyazaki 134
70 Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb 1964 8.4 Stanley Kubrick 95
71 The Dark Knight Rises 2012 8.4 Christopher Nolan 164
72 Once Upon a Time in America 1984 8.4 Sergio Leone 229
73 Your Name. 2016 8.4 Makoto Shinkai 106
75 Coco 2017 8.4 Lee Unkrich 105
76 Avengers: Endgame 2019 8.4 Anthony Russo 181
77 Capernaum 2018 8.4 Nadine Labaki 126
80 High and Low 1963 8.4 Akira Kurosawa 143
83 3 Idiots 2009 8.4 Rajkumar Hirani 170
88 Like Stars on Earth 2007 8.4 Aamir Khan 165
97 Dangal 2016 8.4 Nitesh Tiwari 161
243 Drishyam 2013 8.4 Jeethu Joseph 160
31 Léon: The Professional 1994 8.5 Luc Besson 110
33 The Usual Suspects 1995 8.5 Bryan Singer 106
34 The Lion King 1994 8.5 Roger Allers 88
35 The Pianist 2002 8.5 Roman Polanski 150
36 Terminator 2: Judgment Day 1991 8.5 James Cameron 137
37 Back to the Future 1985 8.5 Robert Zemeckis 116
38 American History X 1998 8.5 Tony Kaye 119
39 Modern Times 1936 8.5 Charles Chaplin 87
40 Gladiator 2000 8.5 Ridley Scott 155
41 Psycho 1960 8.5 Alfred Hitchcock 109
42 The Departed 2006 8.5 Martin Scorsese 151
43 City Lights 1931 8.5 Charles Chaplin 87
44 The Intouchables 2011 8.5 Olivier Nakache 112
45 Whiplash 2014 8.5 Damien Chazelle 106
46 Grave of the Fireflies 1988 8.5 Isao Takahata 89
47 The Prestige 2006 8.5 Christopher Nolan 130
48 Once Upon a Time in the West 1968 8.5 Sergio Leone 165
49 Casablanca 1942 8.5 Michael Curtiz 102
50 Cinema Paradiso 1988 8.5 Giuseppe Tornatore 155
59 Hamilton 2020 8.5 Thomas Kail 160
227 Raatchasan 2018 8.5 Ram Kumar 170
19 Seven Samurai 1954 8.6 Akira Kurosawa 207
20 Se7en 1995 8.6 David Fincher 127
21 Life Is Beautiful 1997 8.6 Roberto Benigni 116
22 City of God 2002 8.6 Fernando Meirelles 130
23 The Silence of the Lambs 1991 8.6 Jonathan Demme 118
24 It's a Wonderful Life 1946 8.6 Frank Capra 130
25 Star Wars: Episode IV - A New Hope 1977 8.6 George Lucas 121
26 Saving Private Ryan 1998 8.6 Steven Spielberg 169
27 The Green Mile 1999 8.6 Frank Darabont 189
28 Spirited Away 2001 8.6 Hayao Miyazaki 125
29 Interstellar 2014 8.6 Christopher Nolan 169
30 Parasite 2019 8.6 Bong Joon Ho 132
32 Hara-Kiri 1962 8.6 Masaki Kobayashi 133
14 The Lord of the Rings: The Two Towers 2002 8.7 Peter Jackson 179
15 Star Wars: Episode V - The Empire Strikes Back 1980 8.7 Irvin Kershner 124
16 The Matrix 1999 8.7 Lana Wachowski 136
17 Goodfellas 1990 8.7 Martin Scorsese 146
18 One Flew Over the Cuckoo's Nest 1975 8.7 Milos Forman 133
9 The Good, the Bad and the Ugly 1966 8.8 Sergio Leone 178
10 The Lord of the Rings: The Fellowship of the Ring 2001 8.8 Peter Jackson 178
11 Fight Club 1999 8.8 David Fincher 139
12 Forrest Gump 1994 8.8 Robert Zemeckis 142
13 Inception 2010 8.8 Christopher Nolan 148
6 Schindler's List 1993 8.9 Steven Spielberg 195
7 The Lord of the Rings: The Return of the King 2003 8.9 Peter Jackson 201
8 Pulp Fiction 1994 8.9 Quentin Tarantino 154
3 The Godfather: Part II 1974 9 Francis Ford Coppola 202
4 The Dark Knight 2008 9 Christopher Nolan 152
5 12 Angry Men 1957 9 Sidney Lumet 96
2 The Godfather 1972 9.2 Francis Ford Coppola 175
1 The Shawshank Redemption 1994 9.3 Frank Darabont 142
250 rows in set (0.00 sec)

如果指定排序的變數是文字（TEXT）類型，遞增的規範是由 A 到 Z¶

In [7]:
SELECT *
  FROM movies
 ORDER BY director;
Out[7]:
id title release_year rating director runtime
88 Like Stars on Earth 2007 8.4 Aamir Khan 165
186 Mary and Max 2009 8.1 Adam Elliot 92
19 Seven Samurai 1954 8.6 Akira Kurosawa 207
80 High and Low 1963 8.4 Akira Kurosawa 143
104 Ikiru 1952 8.3 Akira Kurosawa 143
128 Yojimbo 1961 8.2 Akira Kurosawa 110
130 Rashomon 1950 8.2 Akira Kurosawa 88
133 Ran 1985 8.2 Akira Kurosawa 162
230 Amores Perros 2000 8.1 Alejandro G. Iñárritu 154
41 Psycho 1960 8.5 Alfred Hitchcock 109
51 Rear Window 1954 8.4 Alfred Hitchcock 112
93 Vertigo 1958 8.3 Alfred Hitchcock 128
105 North by Northwest 1959 8.3 Alfred Hitchcock 136
150 Dial M for Murder 1954 8.2 Alfred Hitchcock 105
236 Rebecca 1940 8.1 Alfred Hitchcock 130
171 Stalker 1979 8.2 Andrei Tarkovsky 162
232 Andrei Rublev 1966 8.1 Andrei Tarkovsky 205
61 WALL·E 2008 8.4 Andrew Stanton 98
170 Finding Nemo 2003 8.1 Andrew Stanton 100
64 Avengers: Infinity War 2018 8.4 Anthony Russo 149
76 Avengers: Endgame 2019 8.4 Anthony Russo 181
229 Gangs of Wasseypur 2012 8.2 Anurag Kashyap 321
111 A Separation 2011 8.3 Asghar Farhadi 123
250 Swades 2004 8.2 Ashutosh Gowariker 189
65 Sunset Blvd. 1950 8.4 Billy Wilder 110
66 Witness for the Prosecution 1957 8.4 Billy Wilder 116
117 The Apartment 1960 8.3 Billy Wilder 125
119 Double Indemnity 1944 8.3 Billy Wilder 107
135 Some Like It Hot 1959 8.2 Billy Wilder 121
68 Spider-Man: Into the Spider-Verse 2018 8.4 Bob Persichetti 117
30 Parasite 2019 8.6 Bong Joon Ho 132
173 Memories of Murder 2003 8.1 Bong Joon Ho 132
107 Scarface 1983 8.3 Brian De Palma 170
33 The Usual Suspects 1995 8.5 Bryan Singer 106
195 Sherlock Jr. 1924 8.2 Buster Keaton 45
225 The Passion of Joan of Arc 1928 8.1 Carl Theodor Dreyer 114
181 The Third Man 1949 8.1 Carol Reed 93
67 Oldboy 2003 8.4 Chan-wook Park 120
215 The Handmaiden 2016 8.1 Chan-wook Park 145
39 Modern Times 1936 8.5 Charles Chaplin 87
43 City Lights 1931 8.5 Charles Chaplin 87
55 The Great Dictator 1940 8.4 Charles Chaplin 125
99 The Kid 1921 8.3 Charles Chaplin 68
153 The Gold Rush 1925 8.2 Charles Chaplin 95
4 The Dark Knight 2008 9 Christopher Nolan 152
13 Inception 2010 8.8 Christopher Nolan 148
29 Interstellar 2014 8.6 Christopher Nolan 169
47 The Prestige 2006 8.5 Christopher Nolan 130
54 Memento 2000 8.4 Christopher Nolan 113
71 The Dark Knight Rises 2012 8.4 Christopher Nolan 164
127 Batman Begins 2005 8.2 Christopher Nolan 140
134 Unforgiven 1992 8.2 Clint Eastwood 130
182 Gran Torino 2008 8.1 Clint Eastwood 116
209 Million Dollar Baby 2004 8.1 Clint Eastwood 132
199 The General 1926 8.1 Clyde Bruckman 67
124 L.A. Confidential 1997 8.2 Curtis Hanson 138
244 Portrait of a Lady on Fire 2019 8.1 Céline Sciamma 122
45 Whiplash 2014 8.5 Damien Chazelle 106
178 Wild Tales 2014 8.1 Damián Szifron 122
166 Trainspotting 1996 8.1 Danny Boyle 93
91 Requiem for a Dream 2000 8.3 Darren Aronofsky 102
11 Fight Club 1999 8.8 David Fincher 139
20 Se7en 1995 8.6 David Fincher 127
190 Gone Girl 2014 8.1 David Fincher 149
114 Lawrence of Arabia 1962 8.3 David Lean 228
176 The Bridge on the River Kwai 1957 8.1 David Lean 161
160 The Elephant Man 1980 8.1 David Lynch 124
210 Harry Potter and the Deathly Hallows: Part 2 2011 8.1 David Yates 130
200 How to Train Your Dragon 2010 8.1 Dean DeBlois 98
110 Incendies 2010 8.3 Denis Villeneuve 131
192 Prisoners 2013 8.1 Denis Villeneuve 153
102 Come and See 1985 8.3 Elem Klimov 142
183 On the Waterfront 1954 8.1 Elia Kazan 108
237 Time of the Gypsies 1988 8.2 Emir Kusturica 142
197 To Be or Not to Be 1942 8.2 Ernst Lubitsch 99
156 No Country for Old Men 2007 8.1 Ethan Coen 122
22 City of God 2002 8.6 Fernando Meirelles 130
58 The Lives of Others 2006 8.4 Florian Henckel von Donnersmarck 137
2 The Godfather 1972 9.2 Francis Ford Coppola 175
3 The Godfather: Part II 1974 9 Francis Ford Coppola 202
53 Apocalypse Now 1979 8.4 Francis Ford Coppola 147
24 It's a Wonderful Life 1946 8.6 Frank Capra 130
205 Mr. Smith Goes to Washington 1939 8.1 Frank Capra 129
245 It Happened One Night 1934 8.1 Frank Capra 105
1 The Shawshank Redemption 1994 9.3 Frank Darabont 142
27 The Green Mile 1999 8.6 Frank Darabont 189
224 The 400 Blows 1959 8.1 François Truffaut 99
94 M 1931 8.3 Fritz Lang 99
116 Metropolis 1927 8.3 Fritz Lang 153
163 Warrior 2011 8.2 Gavin O'Connor 140
25 Star Wars: Episode IV - A New Hope 1977 8.6 George Lucas 121
206 Mad Max: Fury Road 2015 8.1 George Miller 120
113 The Sting 1973 8.3 George Roy Hill 129
50 Cinema Paradiso 1988 8.5 Giuseppe Tornatore 155
142 Pan's Labyrinth 2006 8.2 Guillermo del Toro 118
86 Good Will Hunting 1997 8.3 Gus Van Sant 126
103 Snatch 2000 8.3 Guy Ritchie 102
145 Lock, Stock and Two Smoking Barrels 1998 8.2 Guy Ritchie 107
28 Spirited Away 2001 8.6 Hayao Miyazaki 125
69 Princess Mononoke 1997 8.4 Hayao Miyazaki 134
136 Howl's Moving Castle 2004 8.2 Hayao Miyazaki 119
148 My Neighbor Totoro 1988 8.2 Hayao Miyazaki 86
235 Nausicaä of the Valley of the Wind 1984 8.1 Hayao Miyazaki 117
219 The Wages of Fear 1953 8.1 Henri-Georges Clouzot 131
246 Neon Genesis Evangelion: The End of Evangelion 1997 8.1 Hideaki Anno 87
207 Anand 1971 8.3 Hrishikesh Mukherjee 122
161 The Seventh Seal 1957 8.2 Ingmar Bergman 96
172 Wild Strawberries 1957 8.2 Ingmar Bergman 91
193 Persona 1966 8.1 Ingmar Bergman 83
204 Autumn Sonata 1978 8.2 Ingmar Bergman 99
15 Star Wars: Episode V - The Empire Strikes Back 1980 8.7 Irvin Kershner 124
46 Grave of the Fireflies 1988 8.5 Isao Takahata 89
36 Terminator 2: Judgment Day 1991 8.5 James Cameron 137
74 Aliens 1986 8.3 James Cameron 137
201 Ford v Ferrari 2019 8.1 James Mangold 152
217 Logan 2017 8.1 James Mangold 137
157 V for Vendetta 2005 8.2 James McTeigue 132
115 Amélie 2001 8.3 Jean-Pierre Jeunet 122
243 Drishyam 2013 8.4 Jeethu Joseph 160
185 In the Name of the Father 1993 8.1 Jim Sheridan 133
177 Fargo 1996 8.1 Joel Coen 98
196 The Big Lebowski 1998 8.1 Joel Coen 117
159 The Thing 1982 8.1 John Carpenter 109
234 Rocky 1976 8.1 John G. Avildsen 120
149 The Treasure of the Sierra Madre 1948 8.2 John Huston 126
82 Toy Story 1995 8.3 John Lasseter 81
126 Die Hard 1988 8.2 John McTiernan 132
141 The Great Escape 1963 8.2 John Sturges 172
23 The Silence of the Lambs 1991 8.6 Jonathan Demme 118
137 All About Eve 1950 8.2 Joseph L. Mankiewicz 138
144 The Secret in Their Eyes 2009 8.2 Juan José Campanella 129
240 Rififi 1955 8.1 Jules Dassin 118
239 In the Mood for Love 2000 8.1 Kar-Wai Wong 98
16 The Matrix 1999 8.7 Lana Wachowski 136
214 Hachi: A Dog's Tale 2009 8.1 Lasse Hallström 93
75 Coco 2017 8.4 Lee Unkrich 105
112 Toy Story 3 2010 8.2 Lee Unkrich 103
179 Room 2015 8.1 Lenny Abrahamson 118
31 Léon: The Professional 1994 8.5 Luc Besson 110
162 The Sixth Sense 1999 8.1 M. Night Shyamalan 107
132 Children of Heaven 1997 8.3 Majid Majidi 89
73 Your Name. 2016 8.4 Makoto Shinkai 106
152 Three Billboards Outside Ebbing, Missouri 2017 8.1 Martin McDonagh 115
17 Goodfellas 1990 8.7 Martin Scorsese 146
42 The Departed 2006 8.5 Martin Scorsese 151
109 Taxi Driver 1976 8.2 Martin Scorsese 114
138 Casino 1995 8.2 Martin Scorsese 178
140 The Wolf of Wall Street 2013 8.2 Martin Scorsese 180
147 Raging Bull 1980 8.2 Martin Scorsese 129
151 Shutter Island 2010 8.2 Martin Scorsese 138
32 Hara-Kiri 1962 8.6 Masaki Kobayashi 133
222 La Haine 1995 8.1 Mathieu Kassovitz 98
247 7 Kogustaki Mucize 2019 8.2 Mehmet Ada Öztekin 132
79 Braveheart 1995 8.3 Mel Gibson 178
191 Hacksaw Ridge 2016 8.1 Mel Gibson 139
184 The Deer Hunter 1978 8.1 Michael Cimino 183
49 Casablanca 1942 8.5 Michael Curtiz 102
123 Heat 1995 8.2 Michael Mann 170
95 Eternal Sunshine of the Spotless Mind 2004 8.3 Michel Gondry 108
18 One Flew Over the Cuckoo's Nest 1975 8.7 Milos Forman 133
84 Amadeus 1984 8.3 Milos Forman 160
77 Capernaum 2018 8.4 Nadine Labaki 126
249 Drishyam 2015 8.2 Nishikant Kamat 163
97 Dangal 2016 8.4 Nitesh Tiwari 161
131 Downfall 2004 8.2 Oliver Hirschbiegel 156
218 Platoon 1986 8.1 Oliver Stone 120
44 The Intouchables 2011 8.5 Olivier Nakache 112
96 Citizen Kane 1941 8.3 Orson Welles 119
143 There Will Be Blood 2007 8.2 Paul Thomas Anderson 158
121 Up 2009 8.2 Pete Docter 96
158 Inside Out 2015 8.1 Pete Docter 95
231 Soul 2020 8.1 Pete Docter 100
233 Monsters, Inc. 2001 8.1 Pete Docter 92
125 Green Book 2018 8.2 Peter Farrelly 130
7 The Lord of the Rings: The Return of the King 2003 8.9 Peter Jackson 201
10 The Lord of the Rings: The Fellowship of the Ring 2001 8.8 Peter Jackson 178
14 The Lord of the Rings: The Two Towers 2002 8.7 Peter Jackson 179
168 The Truman Show 1998 8.1 Peter Weir 103
208 Dead Poets Society 1989 8.1 Peter Weir 128
8 Pulp Fiction 1994 8.9 Quentin Tarantino 154
57 Django Unchained 2012 8.4 Quentin Tarantino 165
85 Inglourious Basterds 2009 8.3 Quentin Tarantino 153
89 Reservoir Dogs 1992 8.3 Quentin Tarantino 99
174 Kill Bill: Vol. 1 2003 8.1 Quentin Tarantino 111
83 3 Idiots 2009 8.4 Rajkumar Hirani 170
241 Rang De Basanti 2006 8.2 Rakeysh Omprakash Mehra 167
227 Raatchasan 2018 8.5 Ram Kumar 170
187 Before Sunrise 1995 8.1 Richard Linklater 101
238 Before Sunset 2004 8.1 Richard Linklater 80
87 Star Wars: Episode VI - Return of the Jedi 1983 8.3 Richard Marquand 131
40 Gladiator 2000 8.5 Ridley Scott 155
52 Alien 1979 8.4 Ridley Scott 117
175 Blade Runner 1982 8.1 Ridley Scott 117
211 Stand by Me 1986 8.1 Rob Reiner 89
120 To Kill a Mockingbird 1962 8.2 Robert Mulligan 129
12 Forrest Gump 1994 8.8 Robert Zemeckis 142
37 Back to the Future 1985 8.5 Robert Zemeckis 116
21 Life Is Beautiful 1997 8.6 Roberto Benigni 116
34 The Lion King 1994 8.5 Roger Allers 88
35 The Pianist 2002 8.5 Roman Polanski 150
154 Chinatown 1974 8.1 Roman Polanski 130
139 A Beautiful Mind 2001 8.2 Ron Howard 135
221 Rush 2013 8.1 Ron Howard 123
78 American Beauty 1999 8.3 Sam Mendes 122
108 1917 2019 8.3 Sam Mendes 119
220 Into the Wild 2007 8.1 Sean Penn 148
9 The Good, the Bad and the Ugly 1966 8.8 Sergio Leone 178
48 Once Upon a Time in the West 1968 8.5 Sergio Leone 165
72 Once Upon a Time in America 1984 8.4 Sergio Leone 229
118 For a Few Dollars More 1965 8.2 Sergio Leone 132
165 Klaus 2019 8.2 Sergio Pablos 96
5 12 Angry Men 1957 9 Sidney Lumet 96
212 Network 1976 8.1 Sidney Lumet 121
194 Andhadhun 2018 8.3 Sriram Raghavan 139
98 Singin' in the Rain 1952 8.3 Stanley Donen 103
146 Judgment at Nuremberg 1961 8.2 Stanley Kramer 179
60 Paths of Glory 1957 8.4 Stanley Kubrick 88
63 The Shining 1980 8.4 Stanley Kubrick 146
70 Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb 1964 8.4 Stanley Kubrick 95
90 2001: A Space Odyssey 1968 8.3 Stanley Kubrick 149
101 Full Metal Jacket 1987 8.3 Stanley Kubrick 116
106 A Clockwork Orange 1971 8.3 Stanley Kubrick 136
198 Barry Lyndon 1975 8.1 Stanley Kubrick 185
202 12 Years a Slave 2013 8.1 Steve McQueen 134
6 Schindler's List 1993 8.9 Steven Spielberg 195
26 Saving Private Ryan 1998 8.6 Steven Spielberg 169
56 Indiana Jones and the Raiders of the Lost Ark 1981 8.4 Steven Spielberg 115
122 Indiana Jones and the Last Crusade 1989 8.2 Steven Spielberg 127
164 Jurassic Park 1993 8.1 Steven Spielberg 127
189 Catch Me If You Can 2002 8.1 Steven Spielberg 141
216 Cool Hand Luke 1967 8.1 Stuart Rosenberg 127
228 Hotel Rwanda 2004 8.1 Terry George 121
129 Monty Python and the Holy Grail 1975 8.2 Terry Gilliam 91
223 Monty Python's Life of Brian 1979 8.1 Terry Jones 94
59 Hamilton 2020 8.5 Thomas Kail 160
92 The Hunt 2012 8.3 Thomas Vinterberg 115
62 Joker 2019 8.4 Todd Phillips 122
226 Spotlight 2015 8.1 Tom McCarthy 129
38 American History X 1998 8.5 Tony Kaye 119
169 Gone with the Wind 1939 8.1 Victor Fleming 238
100 Bicycle Thieves 1948 8.3 Vittorio De Sica 89
188 The Grand Budapest Hotel 2014 8.1 Wes Anderson 99
213 Ben-Hur 1959 8.1 William Wyler 212
242 Paris, Texas 1984 8.1 Wim Wenders 145
81 Das Boot 1981 8.3 Wolfgang Petersen 149
180 Tokyo Story 1953 8.2 Yasujirô Ozu 136
203 The Bandit 1996 8.2 Yavuz Turgul 128
167 Zack Snyder's Justice League 2021 8.3 Zack Snyder 242
248 Tangerines 2013 8.2 Zaza Urushadze 87
155 My Father and My Son 2005 8.3 Çagan Irmak 112
250 rows in set (0.00 sec)

如果希望讓查詢結果遞減排序，必須加上保留字 DESC（Descending）¶

In [8]:
SELECT *
  FROM movies
 ORDER BY rating DESC;
Out[8]:
id title release_year rating director runtime
1 The Shawshank Redemption 1994 9.3 Frank Darabont 142
2 The Godfather 1972 9.2 Francis Ford Coppola 175
3 The Godfather: Part II 1974 9 Francis Ford Coppola 202
4 The Dark Knight 2008 9 Christopher Nolan 152
5 12 Angry Men 1957 9 Sidney Lumet 96
6 Schindler's List 1993 8.9 Steven Spielberg 195
7 The Lord of the Rings: The Return of the King 2003 8.9 Peter Jackson 201
8 Pulp Fiction 1994 8.9 Quentin Tarantino 154
9 The Good, the Bad and the Ugly 1966 8.8 Sergio Leone 178
10 The Lord of the Rings: The Fellowship of the Ring 2001 8.8 Peter Jackson 178
11 Fight Club 1999 8.8 David Fincher 139
12 Forrest Gump 1994 8.8 Robert Zemeckis 142
13 Inception 2010 8.8 Christopher Nolan 148
14 The Lord of the Rings: The Two Towers 2002 8.7 Peter Jackson 179
15 Star Wars: Episode V - The Empire Strikes Back 1980 8.7 Irvin Kershner 124
16 The Matrix 1999 8.7 Lana Wachowski 136
17 Goodfellas 1990 8.7 Martin Scorsese 146
18 One Flew Over the Cuckoo's Nest 1975 8.7 Milos Forman 133
19 Seven Samurai 1954 8.6 Akira Kurosawa 207
20 Se7en 1995 8.6 David Fincher 127
21 Life Is Beautiful 1997 8.6 Roberto Benigni 116
22 City of God 2002 8.6 Fernando Meirelles 130
23 The Silence of the Lambs 1991 8.6 Jonathan Demme 118
24 It's a Wonderful Life 1946 8.6 Frank Capra 130
25 Star Wars: Episode IV - A New Hope 1977 8.6 George Lucas 121
26 Saving Private Ryan 1998 8.6 Steven Spielberg 169
27 The Green Mile 1999 8.6 Frank Darabont 189
28 Spirited Away 2001 8.6 Hayao Miyazaki 125
29 Interstellar 2014 8.6 Christopher Nolan 169
30 Parasite 2019 8.6 Bong Joon Ho 132
32 Hara-Kiri 1962 8.6 Masaki Kobayashi 133
31 Léon: The Professional 1994 8.5 Luc Besson 110
33 The Usual Suspects 1995 8.5 Bryan Singer 106
34 The Lion King 1994 8.5 Roger Allers 88
35 The Pianist 2002 8.5 Roman Polanski 150
36 Terminator 2: Judgment Day 1991 8.5 James Cameron 137
37 Back to the Future 1985 8.5 Robert Zemeckis 116
38 American History X 1998 8.5 Tony Kaye 119
39 Modern Times 1936 8.5 Charles Chaplin 87
40 Gladiator 2000 8.5 Ridley Scott 155
41 Psycho 1960 8.5 Alfred Hitchcock 109
42 The Departed 2006 8.5 Martin Scorsese 151
43 City Lights 1931 8.5 Charles Chaplin 87
44 The Intouchables 2011 8.5 Olivier Nakache 112
45 Whiplash 2014 8.5 Damien Chazelle 106
46 Grave of the Fireflies 1988 8.5 Isao Takahata 89
47 The Prestige 2006 8.5 Christopher Nolan 130
48 Once Upon a Time in the West 1968 8.5 Sergio Leone 165
49 Casablanca 1942 8.5 Michael Curtiz 102
50 Cinema Paradiso 1988 8.5 Giuseppe Tornatore 155
59 Hamilton 2020 8.5 Thomas Kail 160
227 Raatchasan 2018 8.5 Ram Kumar 170
51 Rear Window 1954 8.4 Alfred Hitchcock 112
52 Alien 1979 8.4 Ridley Scott 117
53 Apocalypse Now 1979 8.4 Francis Ford Coppola 147
54 Memento 2000 8.4 Christopher Nolan 113
55 The Great Dictator 1940 8.4 Charles Chaplin 125
56 Indiana Jones and the Raiders of the Lost Ark 1981 8.4 Steven Spielberg 115
57 Django Unchained 2012 8.4 Quentin Tarantino 165
58 The Lives of Others 2006 8.4 Florian Henckel von Donnersmarck 137
60 Paths of Glory 1957 8.4 Stanley Kubrick 88
61 WALL·E 2008 8.4 Andrew Stanton 98
62 Joker 2019 8.4 Todd Phillips 122
63 The Shining 1980 8.4 Stanley Kubrick 146
64 Avengers: Infinity War 2018 8.4 Anthony Russo 149
65 Sunset Blvd. 1950 8.4 Billy Wilder 110
66 Witness for the Prosecution 1957 8.4 Billy Wilder 116
67 Oldboy 2003 8.4 Chan-wook Park 120
68 Spider-Man: Into the Spider-Verse 2018 8.4 Bob Persichetti 117
69 Princess Mononoke 1997 8.4 Hayao Miyazaki 134
70 Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb 1964 8.4 Stanley Kubrick 95
71 The Dark Knight Rises 2012 8.4 Christopher Nolan 164
72 Once Upon a Time in America 1984 8.4 Sergio Leone 229
73 Your Name. 2016 8.4 Makoto Shinkai 106
75 Coco 2017 8.4 Lee Unkrich 105
76 Avengers: Endgame 2019 8.4 Anthony Russo 181
77 Capernaum 2018 8.4 Nadine Labaki 126
80 High and Low 1963 8.4 Akira Kurosawa 143
83 3 Idiots 2009 8.4 Rajkumar Hirani 170
88 Like Stars on Earth 2007 8.4 Aamir Khan 165
97 Dangal 2016 8.4 Nitesh Tiwari 161
243 Drishyam 2013 8.4 Jeethu Joseph 160
74 Aliens 1986 8.3 James Cameron 137
78 American Beauty 1999 8.3 Sam Mendes 122
79 Braveheart 1995 8.3 Mel Gibson 178
81 Das Boot 1981 8.3 Wolfgang Petersen 149
82 Toy Story 1995 8.3 John Lasseter 81
84 Amadeus 1984 8.3 Milos Forman 160
85 Inglourious Basterds 2009 8.3 Quentin Tarantino 153
86 Good Will Hunting 1997 8.3 Gus Van Sant 126
87 Star Wars: Episode VI - Return of the Jedi 1983 8.3 Richard Marquand 131
89 Reservoir Dogs 1992 8.3 Quentin Tarantino 99
90 2001: A Space Odyssey 1968 8.3 Stanley Kubrick 149
91 Requiem for a Dream 2000 8.3 Darren Aronofsky 102
92 The Hunt 2012 8.3 Thomas Vinterberg 115
93 Vertigo 1958 8.3 Alfred Hitchcock 128
94 M 1931 8.3 Fritz Lang 99
95 Eternal Sunshine of the Spotless Mind 2004 8.3 Michel Gondry 108
96 Citizen Kane 1941 8.3 Orson Welles 119
98 Singin' in the Rain 1952 8.3 Stanley Donen 103
99 The Kid 1921 8.3 Charles Chaplin 68
100 Bicycle Thieves 1948 8.3 Vittorio De Sica 89
101 Full Metal Jacket 1987 8.3 Stanley Kubrick 116
102 Come and See 1985 8.3 Elem Klimov 142
103 Snatch 2000 8.3 Guy Ritchie 102
104 Ikiru 1952 8.3 Akira Kurosawa 143
105 North by Northwest 1959 8.3 Alfred Hitchcock 136
106 A Clockwork Orange 1971 8.3 Stanley Kubrick 136
107 Scarface 1983 8.3 Brian De Palma 170
108 1917 2019 8.3 Sam Mendes 119
110 Incendies 2010 8.3 Denis Villeneuve 131
111 A Separation 2011 8.3 Asghar Farhadi 123
113 The Sting 1973 8.3 George Roy Hill 129
114 Lawrence of Arabia 1962 8.3 David Lean 228
115 Amélie 2001 8.3 Jean-Pierre Jeunet 122
116 Metropolis 1927 8.3 Fritz Lang 153
117 The Apartment 1960 8.3 Billy Wilder 125
119 Double Indemnity 1944 8.3 Billy Wilder 107
132 Children of Heaven 1997 8.3 Majid Majidi 89
155 My Father and My Son 2005 8.3 Çagan Irmak 112
167 Zack Snyder's Justice League 2021 8.3 Zack Snyder 242
194 Andhadhun 2018 8.3 Sriram Raghavan 139
207 Anand 1971 8.3 Hrishikesh Mukherjee 122
109 Taxi Driver 1976 8.2 Martin Scorsese 114
112 Toy Story 3 2010 8.2 Lee Unkrich 103
118 For a Few Dollars More 1965 8.2 Sergio Leone 132
120 To Kill a Mockingbird 1962 8.2 Robert Mulligan 129
121 Up 2009 8.2 Pete Docter 96
122 Indiana Jones and the Last Crusade 1989 8.2 Steven Spielberg 127
123 Heat 1995 8.2 Michael Mann 170
124 L.A. Confidential 1997 8.2 Curtis Hanson 138
125 Green Book 2018 8.2 Peter Farrelly 130
126 Die Hard 1988 8.2 John McTiernan 132
127 Batman Begins 2005 8.2 Christopher Nolan 140
128 Yojimbo 1961 8.2 Akira Kurosawa 110
129 Monty Python and the Holy Grail 1975 8.2 Terry Gilliam 91
130 Rashomon 1950 8.2 Akira Kurosawa 88
131 Downfall 2004 8.2 Oliver Hirschbiegel 156
133 Ran 1985 8.2 Akira Kurosawa 162
134 Unforgiven 1992 8.2 Clint Eastwood 130
135 Some Like It Hot 1959 8.2 Billy Wilder 121
136 Howl's Moving Castle 2004 8.2 Hayao Miyazaki 119
137 All About Eve 1950 8.2 Joseph L. Mankiewicz 138
138 Casino 1995 8.2 Martin Scorsese 178
139 A Beautiful Mind 2001 8.2 Ron Howard 135
140 The Wolf of Wall Street 2013 8.2 Martin Scorsese 180
141 The Great Escape 1963 8.2 John Sturges 172
142 Pan's Labyrinth 2006 8.2 Guillermo del Toro 118
143 There Will Be Blood 2007 8.2 Paul Thomas Anderson 158
144 The Secret in Their Eyes 2009 8.2 Juan José Campanella 129
145 Lock, Stock and Two Smoking Barrels 1998 8.2 Guy Ritchie 107
146 Judgment at Nuremberg 1961 8.2 Stanley Kramer 179
147 Raging Bull 1980 8.2 Martin Scorsese 129
148 My Neighbor Totoro 1988 8.2 Hayao Miyazaki 86
149 The Treasure of the Sierra Madre 1948 8.2 John Huston 126
150 Dial M for Murder 1954 8.2 Alfred Hitchcock 105
151 Shutter Island 2010 8.2 Martin Scorsese 138
153 The Gold Rush 1925 8.2 Charles Chaplin 95
157 V for Vendetta 2005 8.2 James McTeigue 132
161 The Seventh Seal 1957 8.2 Ingmar Bergman 96
163 Warrior 2011 8.2 Gavin O'Connor 140
165 Klaus 2019 8.2 Sergio Pablos 96
171 Stalker 1979 8.2 Andrei Tarkovsky 162
172 Wild Strawberries 1957 8.2 Ingmar Bergman 91
180 Tokyo Story 1953 8.2 Yasujirô Ozu 136
195 Sherlock Jr. 1924 8.2 Buster Keaton 45
197 To Be or Not to Be 1942 8.2 Ernst Lubitsch 99
203 The Bandit 1996 8.2 Yavuz Turgul 128
204 Autumn Sonata 1978 8.2 Ingmar Bergman 99
229 Gangs of Wasseypur 2012 8.2 Anurag Kashyap 321
237 Time of the Gypsies 1988 8.2 Emir Kusturica 142
241 Rang De Basanti 2006 8.2 Rakeysh Omprakash Mehra 167
247 7 Kogustaki Mucize 2019 8.2 Mehmet Ada Öztekin 132
248 Tangerines 2013 8.2 Zaza Urushadze 87
249 Drishyam 2015 8.2 Nishikant Kamat 163
250 Swades 2004 8.2 Ashutosh Gowariker 189
152 Three Billboards Outside Ebbing, Missouri 2017 8.1 Martin McDonagh 115
154 Chinatown 1974 8.1 Roman Polanski 130
156 No Country for Old Men 2007 8.1 Ethan Coen 122
158 Inside Out 2015 8.1 Pete Docter 95
159 The Thing 1982 8.1 John Carpenter 109
160 The Elephant Man 1980 8.1 David Lynch 124
162 The Sixth Sense 1999 8.1 M. Night Shyamalan 107
164 Jurassic Park 1993 8.1 Steven Spielberg 127
166 Trainspotting 1996 8.1 Danny Boyle 93
168 The Truman Show 1998 8.1 Peter Weir 103
169 Gone with the Wind 1939 8.1 Victor Fleming 238
170 Finding Nemo 2003 8.1 Andrew Stanton 100
173 Memories of Murder 2003 8.1 Bong Joon Ho 132
174 Kill Bill: Vol. 1 2003 8.1 Quentin Tarantino 111
175 Blade Runner 1982 8.1 Ridley Scott 117
176 The Bridge on the River Kwai 1957 8.1 David Lean 161
177 Fargo 1996 8.1 Joel Coen 98
178 Wild Tales 2014 8.1 Damián Szifron 122
179 Room 2015 8.1 Lenny Abrahamson 118
181 The Third Man 1949 8.1 Carol Reed 93
182 Gran Torino 2008 8.1 Clint Eastwood 116
183 On the Waterfront 1954 8.1 Elia Kazan 108
184 The Deer Hunter 1978 8.1 Michael Cimino 183
185 In the Name of the Father 1993 8.1 Jim Sheridan 133
186 Mary and Max 2009 8.1 Adam Elliot 92
187 Before Sunrise 1995 8.1 Richard Linklater 101
188 The Grand Budapest Hotel 2014 8.1 Wes Anderson 99
189 Catch Me If You Can 2002 8.1 Steven Spielberg 141
190 Gone Girl 2014 8.1 David Fincher 149
191 Hacksaw Ridge 2016 8.1 Mel Gibson 139
192 Prisoners 2013 8.1 Denis Villeneuve 153
193 Persona 1966 8.1 Ingmar Bergman 83
196 The Big Lebowski 1998 8.1 Joel Coen 117
198 Barry Lyndon 1975 8.1 Stanley Kubrick 185
199 The General 1926 8.1 Clyde Bruckman 67
200 How to Train Your Dragon 2010 8.1 Dean DeBlois 98
201 Ford v Ferrari 2019 8.1 James Mangold 152
202 12 Years a Slave 2013 8.1 Steve McQueen 134
205 Mr. Smith Goes to Washington 1939 8.1 Frank Capra 129
206 Mad Max: Fury Road 2015 8.1 George Miller 120
208 Dead Poets Society 1989 8.1 Peter Weir 128
209 Million Dollar Baby 2004 8.1 Clint Eastwood 132
210 Harry Potter and the Deathly Hallows: Part 2 2011 8.1 David Yates 130
211 Stand by Me 1986 8.1 Rob Reiner 89
212 Network 1976 8.1 Sidney Lumet 121
213 Ben-Hur 1959 8.1 William Wyler 212
214 Hachi: A Dog's Tale 2009 8.1 Lasse Hallström 93
215 The Handmaiden 2016 8.1 Chan-wook Park 145
216 Cool Hand Luke 1967 8.1 Stuart Rosenberg 127
217 Logan 2017 8.1 James Mangold 137
218 Platoon 1986 8.1 Oliver Stone 120
219 The Wages of Fear 1953 8.1 Henri-Georges Clouzot 131
220 Into the Wild 2007 8.1 Sean Penn 148
221 Rush 2013 8.1 Ron Howard 123
222 La Haine 1995 8.1 Mathieu Kassovitz 98
223 Monty Python's Life of Brian 1979 8.1 Terry Jones 94
224 The 400 Blows 1959 8.1 François Truffaut 99
225 The Passion of Joan of Arc 1928 8.1 Carl Theodor Dreyer 114
226 Spotlight 2015 8.1 Tom McCarthy 129
228 Hotel Rwanda 2004 8.1 Terry George 121
230 Amores Perros 2000 8.1 Alejandro G. Iñárritu 154
231 Soul 2020 8.1 Pete Docter 100
232 Andrei Rublev 1966 8.1 Andrei Tarkovsky 205
233 Monsters, Inc. 2001 8.1 Pete Docter 92
234 Rocky 1976 8.1 John G. Avildsen 120
235 Nausicaä of the Valley of the Wind 1984 8.1 Hayao Miyazaki 117
236 Rebecca 1940 8.1 Alfred Hitchcock 130
238 Before Sunset 2004 8.1 Richard Linklater 80
239 In the Mood for Love 2000 8.1 Kar-Wai Wong 98
240 Rififi 1955 8.1 Jules Dassin 118
242 Paris, Texas 1984 8.1 Wim Wenders 145
244 Portrait of a Lady on Fire 2019 8.1 Céline Sciamma 122
245 It Happened One Night 1934 8.1 Frank Capra 105
246 Neon Genesis Evangelion: The End of Evangelion 1997 8.1 Hideaki Anno 87
250 rows in set (0.00 sec)

使用多個變數排序¶

在 ORDER BY 後，可以指定多個變數搭配各自的排序方式¶

指定多個變數排序時，會依照「先指定」的變數排序，在「先指定」的變數排序相同的情況下再依據「後指定」的變數排序。

In [9]:
SELECT *
  FROM movies
 ORDER BY release_year DESC, -- 先指定 release_year 遞減排序
          rating;            -- 後指定 rating 遞增排序
Out[9]:
id title release_year rating director runtime
167 Zack Snyder's Justice League 2021 8.3 Zack Snyder 242
231 Soul 2020 8.1 Pete Docter 100
59 Hamilton 2020 8.5 Thomas Kail 160
201 Ford v Ferrari 2019 8.1 James Mangold 152
244 Portrait of a Lady on Fire 2019 8.1 Céline Sciamma 122
165 Klaus 2019 8.2 Sergio Pablos 96
247 7 Kogustaki Mucize 2019 8.2 Mehmet Ada Öztekin 132
108 1917 2019 8.3 Sam Mendes 119
62 Joker 2019 8.4 Todd Phillips 122
76 Avengers: Endgame 2019 8.4 Anthony Russo 181
30 Parasite 2019 8.6 Bong Joon Ho 132
125 Green Book 2018 8.2 Peter Farrelly 130
194 Andhadhun 2018 8.3 Sriram Raghavan 139
64 Avengers: Infinity War 2018 8.4 Anthony Russo 149
68 Spider-Man: Into the Spider-Verse 2018 8.4 Bob Persichetti 117
77 Capernaum 2018 8.4 Nadine Labaki 126
227 Raatchasan 2018 8.5 Ram Kumar 170
152 Three Billboards Outside Ebbing, Missouri 2017 8.1 Martin McDonagh 115
217 Logan 2017 8.1 James Mangold 137
75 Coco 2017 8.4 Lee Unkrich 105
191 Hacksaw Ridge 2016 8.1 Mel Gibson 139
215 The Handmaiden 2016 8.1 Chan-wook Park 145
73 Your Name. 2016 8.4 Makoto Shinkai 106
97 Dangal 2016 8.4 Nitesh Tiwari 161
158 Inside Out 2015 8.1 Pete Docter 95
179 Room 2015 8.1 Lenny Abrahamson 118
206 Mad Max: Fury Road 2015 8.1 George Miller 120
226 Spotlight 2015 8.1 Tom McCarthy 129
249 Drishyam 2015 8.2 Nishikant Kamat 163
178 Wild Tales 2014 8.1 Damián Szifron 122
188 The Grand Budapest Hotel 2014 8.1 Wes Anderson 99
190 Gone Girl 2014 8.1 David Fincher 149
45 Whiplash 2014 8.5 Damien Chazelle 106
29 Interstellar 2014 8.6 Christopher Nolan 169
192 Prisoners 2013 8.1 Denis Villeneuve 153
202 12 Years a Slave 2013 8.1 Steve McQueen 134
221 Rush 2013 8.1 Ron Howard 123
140 The Wolf of Wall Street 2013 8.2 Martin Scorsese 180
248 Tangerines 2013 8.2 Zaza Urushadze 87
243 Drishyam 2013 8.4 Jeethu Joseph 160
229 Gangs of Wasseypur 2012 8.2 Anurag Kashyap 321
92 The Hunt 2012 8.3 Thomas Vinterberg 115
57 Django Unchained 2012 8.4 Quentin Tarantino 165
71 The Dark Knight Rises 2012 8.4 Christopher Nolan 164
210 Harry Potter and the Deathly Hallows: Part 2 2011 8.1 David Yates 130
163 Warrior 2011 8.2 Gavin O'Connor 140
111 A Separation 2011 8.3 Asghar Farhadi 123
44 The Intouchables 2011 8.5 Olivier Nakache 112
200 How to Train Your Dragon 2010 8.1 Dean DeBlois 98
112 Toy Story 3 2010 8.2 Lee Unkrich 103
151 Shutter Island 2010 8.2 Martin Scorsese 138
110 Incendies 2010 8.3 Denis Villeneuve 131
13 Inception 2010 8.8 Christopher Nolan 148
186 Mary and Max 2009 8.1 Adam Elliot 92
214 Hachi: A Dog's Tale 2009 8.1 Lasse Hallström 93
121 Up 2009 8.2 Pete Docter 96
144 The Secret in Their Eyes 2009 8.2 Juan José Campanella 129
85 Inglourious Basterds 2009 8.3 Quentin Tarantino 153
83 3 Idiots 2009 8.4 Rajkumar Hirani 170
182 Gran Torino 2008 8.1 Clint Eastwood 116
61 WALL·E 2008 8.4 Andrew Stanton 98
4 The Dark Knight 2008 9 Christopher Nolan 152
156 No Country for Old Men 2007 8.1 Ethan Coen 122
220 Into the Wild 2007 8.1 Sean Penn 148
143 There Will Be Blood 2007 8.2 Paul Thomas Anderson 158
88 Like Stars on Earth 2007 8.4 Aamir Khan 165
142 Pan's Labyrinth 2006 8.2 Guillermo del Toro 118
241 Rang De Basanti 2006 8.2 Rakeysh Omprakash Mehra 167
58 The Lives of Others 2006 8.4 Florian Henckel von Donnersmarck 137
42 The Departed 2006 8.5 Martin Scorsese 151
47 The Prestige 2006 8.5 Christopher Nolan 130
127 Batman Begins 2005 8.2 Christopher Nolan 140
157 V for Vendetta 2005 8.2 James McTeigue 132
155 My Father and My Son 2005 8.3 Çagan Irmak 112
209 Million Dollar Baby 2004 8.1 Clint Eastwood 132
228 Hotel Rwanda 2004 8.1 Terry George 121
238 Before Sunset 2004 8.1 Richard Linklater 80
131 Downfall 2004 8.2 Oliver Hirschbiegel 156
136 Howl's Moving Castle 2004 8.2 Hayao Miyazaki 119
250 Swades 2004 8.2 Ashutosh Gowariker 189
95 Eternal Sunshine of the Spotless Mind 2004 8.3 Michel Gondry 108
170 Finding Nemo 2003 8.1 Andrew Stanton 100
173 Memories of Murder 2003 8.1 Bong Joon Ho 132
174 Kill Bill: Vol. 1 2003 8.1 Quentin Tarantino 111
67 Oldboy 2003 8.4 Chan-wook Park 120
7 The Lord of the Rings: The Return of the King 2003 8.9 Peter Jackson 201
189 Catch Me If You Can 2002 8.1 Steven Spielberg 141
35 The Pianist 2002 8.5 Roman Polanski 150
22 City of God 2002 8.6 Fernando Meirelles 130
14 The Lord of the Rings: The Two Towers 2002 8.7 Peter Jackson 179
233 Monsters, Inc. 2001 8.1 Pete Docter 92
139 A Beautiful Mind 2001 8.2 Ron Howard 135
115 Amélie 2001 8.3 Jean-Pierre Jeunet 122
28 Spirited Away 2001 8.6 Hayao Miyazaki 125
10 The Lord of the Rings: The Fellowship of the Ring 2001 8.8 Peter Jackson 178
230 Amores Perros 2000 8.1 Alejandro G. Iñárritu 154
239 In the Mood for Love 2000 8.1 Kar-Wai Wong 98
91 Requiem for a Dream 2000 8.3 Darren Aronofsky 102
103 Snatch 2000 8.3 Guy Ritchie 102
54 Memento 2000 8.4 Christopher Nolan 113
40 Gladiator 2000 8.5 Ridley Scott 155
162 The Sixth Sense 1999 8.1 M. Night Shyamalan 107
78 American Beauty 1999 8.3 Sam Mendes 122
27 The Green Mile 1999 8.6 Frank Darabont 189
16 The Matrix 1999 8.7 Lana Wachowski 136
11 Fight Club 1999 8.8 David Fincher 139
168 The Truman Show 1998 8.1 Peter Weir 103
196 The Big Lebowski 1998 8.1 Joel Coen 117
145 Lock, Stock and Two Smoking Barrels 1998 8.2 Guy Ritchie 107
38 American History X 1998 8.5 Tony Kaye 119
26 Saving Private Ryan 1998 8.6 Steven Spielberg 169
246 Neon Genesis Evangelion: The End of Evangelion 1997 8.1 Hideaki Anno 87
124 L.A. Confidential 1997 8.2 Curtis Hanson 138
86 Good Will Hunting 1997 8.3 Gus Van Sant 126
132 Children of Heaven 1997 8.3 Majid Majidi 89
69 Princess Mononoke 1997 8.4 Hayao Miyazaki 134
21 Life Is Beautiful 1997 8.6 Roberto Benigni 116
166 Trainspotting 1996 8.1 Danny Boyle 93
177 Fargo 1996 8.1 Joel Coen 98
203 The Bandit 1996 8.2 Yavuz Turgul 128
187 Before Sunrise 1995 8.1 Richard Linklater 101
222 La Haine 1995 8.1 Mathieu Kassovitz 98
123 Heat 1995 8.2 Michael Mann 170
138 Casino 1995 8.2 Martin Scorsese 178
79 Braveheart 1995 8.3 Mel Gibson 178
82 Toy Story 1995 8.3 John Lasseter 81
33 The Usual Suspects 1995 8.5 Bryan Singer 106
20 Se7en 1995 8.6 David Fincher 127
31 Léon: The Professional 1994 8.5 Luc Besson 110
34 The Lion King 1994 8.5 Roger Allers 88
12 Forrest Gump 1994 8.8 Robert Zemeckis 142
8 Pulp Fiction 1994 8.9 Quentin Tarantino 154
1 The Shawshank Redemption 1994 9.3 Frank Darabont 142
164 Jurassic Park 1993 8.1 Steven Spielberg 127
185 In the Name of the Father 1993 8.1 Jim Sheridan 133
6 Schindler's List 1993 8.9 Steven Spielberg 195
134 Unforgiven 1992 8.2 Clint Eastwood 130
89 Reservoir Dogs 1992 8.3 Quentin Tarantino 99
36 Terminator 2: Judgment Day 1991 8.5 James Cameron 137
23 The Silence of the Lambs 1991 8.6 Jonathan Demme 118
17 Goodfellas 1990 8.7 Martin Scorsese 146
208 Dead Poets Society 1989 8.1 Peter Weir 128
122 Indiana Jones and the Last Crusade 1989 8.2 Steven Spielberg 127
126 Die Hard 1988 8.2 John McTiernan 132
148 My Neighbor Totoro 1988 8.2 Hayao Miyazaki 86
237 Time of the Gypsies 1988 8.2 Emir Kusturica 142
46 Grave of the Fireflies 1988 8.5 Isao Takahata 89
50 Cinema Paradiso 1988 8.5 Giuseppe Tornatore 155
101 Full Metal Jacket 1987 8.3 Stanley Kubrick 116
211 Stand by Me 1986 8.1 Rob Reiner 89
218 Platoon 1986 8.1 Oliver Stone 120
74 Aliens 1986 8.3 James Cameron 137
133 Ran 1985 8.2 Akira Kurosawa 162
102 Come and See 1985 8.3 Elem Klimov 142
37 Back to the Future 1985 8.5 Robert Zemeckis 116
235 Nausicaä of the Valley of the Wind 1984 8.1 Hayao Miyazaki 117
242 Paris, Texas 1984 8.1 Wim Wenders 145
84 Amadeus 1984 8.3 Milos Forman 160
72 Once Upon a Time in America 1984 8.4 Sergio Leone 229
87 Star Wars: Episode VI - Return of the Jedi 1983 8.3 Richard Marquand 131
107 Scarface 1983 8.3 Brian De Palma 170
159 The Thing 1982 8.1 John Carpenter 109
175 Blade Runner 1982 8.1 Ridley Scott 117
81 Das Boot 1981 8.3 Wolfgang Petersen 149
56 Indiana Jones and the Raiders of the Lost Ark 1981 8.4 Steven Spielberg 115
160 The Elephant Man 1980 8.1 David Lynch 124
147 Raging Bull 1980 8.2 Martin Scorsese 129
63 The Shining 1980 8.4 Stanley Kubrick 146
15 Star Wars: Episode V - The Empire Strikes Back 1980 8.7 Irvin Kershner 124
223 Monty Python's Life of Brian 1979 8.1 Terry Jones 94
171 Stalker 1979 8.2 Andrei Tarkovsky 162
52 Alien 1979 8.4 Ridley Scott 117
53 Apocalypse Now 1979 8.4 Francis Ford Coppola 147
184 The Deer Hunter 1978 8.1 Michael Cimino 183
204 Autumn Sonata 1978 8.2 Ingmar Bergman 99
25 Star Wars: Episode IV - A New Hope 1977 8.6 George Lucas 121
212 Network 1976 8.1 Sidney Lumet 121
234 Rocky 1976 8.1 John G. Avildsen 120
109 Taxi Driver 1976 8.2 Martin Scorsese 114
198 Barry Lyndon 1975 8.1 Stanley Kubrick 185
129 Monty Python and the Holy Grail 1975 8.2 Terry Gilliam 91
18 One Flew Over the Cuckoo's Nest 1975 8.7 Milos Forman 133
154 Chinatown 1974 8.1 Roman Polanski 130
3 The Godfather: Part II 1974 9 Francis Ford Coppola 202
113 The Sting 1973 8.3 George Roy Hill 129
2 The Godfather 1972 9.2 Francis Ford Coppola 175
106 A Clockwork Orange 1971 8.3 Stanley Kubrick 136
207 Anand 1971 8.3 Hrishikesh Mukherjee 122
90 2001: A Space Odyssey 1968 8.3 Stanley Kubrick 149
48 Once Upon a Time in the West 1968 8.5 Sergio Leone 165
216 Cool Hand Luke 1967 8.1 Stuart Rosenberg 127
193 Persona 1966 8.1 Ingmar Bergman 83
232 Andrei Rublev 1966 8.1 Andrei Tarkovsky 205
9 The Good, the Bad and the Ugly 1966 8.8 Sergio Leone 178
118 For a Few Dollars More 1965 8.2 Sergio Leone 132
70 Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb 1964 8.4 Stanley Kubrick 95
141 The Great Escape 1963 8.2 John Sturges 172
80 High and Low 1963 8.4 Akira Kurosawa 143
120 To Kill a Mockingbird 1962 8.2 Robert Mulligan 129
114 Lawrence of Arabia 1962 8.3 David Lean 228
32 Hara-Kiri 1962 8.6 Masaki Kobayashi 133
128 Yojimbo 1961 8.2 Akira Kurosawa 110
146 Judgment at Nuremberg 1961 8.2 Stanley Kramer 179
117 The Apartment 1960 8.3 Billy Wilder 125
41 Psycho 1960 8.5 Alfred Hitchcock 109
213 Ben-Hur 1959 8.1 William Wyler 212
224 The 400 Blows 1959 8.1 François Truffaut 99
135 Some Like It Hot 1959 8.2 Billy Wilder 121
105 North by Northwest 1959 8.3 Alfred Hitchcock 136
93 Vertigo 1958 8.3 Alfred Hitchcock 128
176 The Bridge on the River Kwai 1957 8.1 David Lean 161
161 The Seventh Seal 1957 8.2 Ingmar Bergman 96
172 Wild Strawberries 1957 8.2 Ingmar Bergman 91
60 Paths of Glory 1957 8.4 Stanley Kubrick 88
66 Witness for the Prosecution 1957 8.4 Billy Wilder 116
5 12 Angry Men 1957 9 Sidney Lumet 96
240 Rififi 1955 8.1 Jules Dassin 118
183 On the Waterfront 1954 8.1 Elia Kazan 108
150 Dial M for Murder 1954 8.2 Alfred Hitchcock 105
51 Rear Window 1954 8.4 Alfred Hitchcock 112
19 Seven Samurai 1954 8.6 Akira Kurosawa 207
219 The Wages of Fear 1953 8.1 Henri-Georges Clouzot 131
180 Tokyo Story 1953 8.2 Yasujirô Ozu 136
98 Singin' in the Rain 1952 8.3 Stanley Donen 103
104 Ikiru 1952 8.3 Akira Kurosawa 143
130 Rashomon 1950 8.2 Akira Kurosawa 88
137 All About Eve 1950 8.2 Joseph L. Mankiewicz 138
65 Sunset Blvd. 1950 8.4 Billy Wilder 110
181 The Third Man 1949 8.1 Carol Reed 93
149 The Treasure of the Sierra Madre 1948 8.2 John Huston 126
100 Bicycle Thieves 1948 8.3 Vittorio De Sica 89
24 It's a Wonderful Life 1946 8.6 Frank Capra 130
119 Double Indemnity 1944 8.3 Billy Wilder 107
197 To Be or Not to Be 1942 8.2 Ernst Lubitsch 99
49 Casablanca 1942 8.5 Michael Curtiz 102
96 Citizen Kane 1941 8.3 Orson Welles 119
236 Rebecca 1940 8.1 Alfred Hitchcock 130
55 The Great Dictator 1940 8.4 Charles Chaplin 125
169 Gone with the Wind 1939 8.1 Victor Fleming 238
205 Mr. Smith Goes to Washington 1939 8.1 Frank Capra 129
39 Modern Times 1936 8.5 Charles Chaplin 87
245 It Happened One Night 1934 8.1 Frank Capra 105
94 M 1931 8.3 Fritz Lang 99
43 City Lights 1931 8.5 Charles Chaplin 87
225 The Passion of Joan of Arc 1928 8.1 Carl Theodor Dreyer 114
116 Metropolis 1927 8.3 Fritz Lang 153
199 The General 1926 8.1 Clyde Bruckman 67
153 The Gold Rush 1925 8.2 Charles Chaplin 95
195 Sherlock Jr. 1924 8.2 Buster Keaton 45
99 The Kid 1921 8.3 Charles Chaplin 68
250 rows in set (0.00 sec)

指定衍生計算欄位排序¶

ORDER BY 除了能夠指定資料表中的變數，還可以指定衍生計算欄位（Calculated fields）作為排序依據¶

In [10]:
SELECT firstName,
       lastName
  FROM players
 ORDER BY weightKilograms / (heightMeters*heightMeters) DESC; -- 以衍生計算欄位 bmi 遞減排序
Out[10]:
firstName lastName
Zion Williamson
Jusuf Nurkic
Jarrell Brantley
Eric Paschall
Udoka Azubuike
Andre Drummond
Nikola Jokic
P.J. Tucker
Vernon Carey Jr.
Paul Millsap
Donovan Mitchell
Talen Horton-Tucker
Eric Bledsoe
Derrick Favors
Jahlil Okafor
Wendell Carter Jr.
Naz Reid
Brook Lopez
Robin Lopez
Bismack Biyombo
Tyler Cook
Stanley Johnson
Jae'Sean Tate
Carsen Edwards
Joel Embiid
Facundo Campazzo
Dwight Howard
Semi Ojeleye
Marcus Smart
Kevin Love
Tacko Fall
Rudy Gay
Julius Randle
Reggie Perry
Isaiah Stewart
Royce O'Neale
Cristiano Felicio
Larry Nance Jr.
Jared Dudley
Anthony Edwards
Grant Williams
Bam Adebayo
Aron Baynes
Jae Crowder
Robert Woodard II
Kelan Martin
DaQuan Jeffries
Tristan Thompson
Malcolm Brogdon
Eric Gordon
Norman Powell
Jamal Murray
Luguentz Dort
JaVale McGee
DeAndre Jordan
Jonas Valanciunas
Steven Adams
Daniel Theis
Xavier Tillman
James Johnson
Montrezl Harrell
Devontae Cacok
Wesley Matthews
Buddy Hield
Denzel Valentine
Carmelo Anthony
LeBron James
Blake Griffin
Reggie Jackson
Mike Scott
Draymond Green
Lamar Stevens
Abdel Nader
Isaac Okoro
Kyle Lowry
Tyus Jones
Anthony Davis
Nathan Knight
Chuma Okeke
Langston Galloway
Jevon Carter
Hassan Whiteside
Nikola Vucevic
Daniel Oturu
Gorgui Dieng
John Wall
Brad Wanamaker
Bryn Forbes
Dennis Smith Jr.
Romeo Langford
Anthony Lamb
Markelle Fultz
Rayjon Tucker
Enes Kanter
Bobby Portis
Boban Marjanovic
Markieff Morris
Drew Eubanks
Solomon Hill
Fred VanVleet
Robert Williams III
Darius Miller
Miles Bridges
Gary Clark
OG Anunoby
Juwan Morgan
Bradley Beal
Tony Bradley
Thomas Bryant
Marc Gasol
James Harden
Keldon Johnson
Nassir Little
Jay Scrubb
Vlatko Cancar
Victor Oladipo
Josh Okogie
Jordan McLaughlin
Mason Plumlee
Udonis Haslem
Jeff Green
Thaddeus Young
Patrick Patterson
Aaron Gordon
Onyeka Okongwu
Devonte' Graham
Payton Pritchard
David Nwaba
Sterling Brown
Jimmy Butler
Cedi Osman
Georges Niang
P.J. Washington
Luka Doncic
Anthony Gill
Jaylen Brown
Jrue Holiday
Kris Dunn
Frank Jackson
Quinndary Weatherspoon
Chris Silva
Justise Winslow
Al Horford
Bruno Fernando
Zeke Nnaji
Derrick Rose
De'Anthony Melton
Tyrese Maxey
D.J. Augustin
Gary Harris
Trent Forrest
Dwayne Bacon
Ignas Brazdeikis
LaMarcus Aldridge
Myles Turner
Willy Hernangomez
Zach Collins
Deandre Ayton
Goga Bitadze
DeMar DeRozan
Joe Harris
Bogdan Bogdanovic
Danuel House Jr.
Darius Garland
Spencer Dinwiddie
Josh Hart
Terance Mann
Max Strus
Garrison Mathews
Aaron Nesmith
Elijah Hughes
Desmond Bane
Bojan Bogdanovic
Thanasis Antetokounmpo
Nicolas Batum
Rui Hachimura
Sekou Doumbouya
Isaiah Roby
Dante Exum
Gordon Hayward
Kawhi Leonard
Doug McDermott
Dillon Brooks
Cameron Reynolds
Karl-Anthony Towns
Nicolo Melli
Keita Bates-Diop
Wayne Ellington
T.J. McConnell
Terry Rozier
Jalen Brunson
Collin Sexton
Kevin Durant
Mike Muscala
Dwight Powell
Clint Capela
Maxi Kleber
JJ Redick
Russell Westbrook
Cory Joseph
Matthew Dellavedova
Malik Monk
Gabe Vincent
Ersan Ilyasova
John Collins
Rudy Gobert
Jared Harper
Tremont Waters
Markus Howard
Trey Burke
Aaron Holiday
Theo Pinson
Kyrie Irving
Damian Lillard
Trey Lyles
Alex Len
Isaiah Hartenstein
JaMychal Green
Rodney McGruder
Javonte Green
Skylar Mays
Sam Merrill
Moritz Wagner
Kemba Walker
Khris Middleton
Khem Birch
Tobias Harris
Andre Iguodala
Danny Green
Klay Thompson
James Ennis III
Troy Brown Jr.
Kenyon Martin Jr.
Lonnie Walker IV
DeAndre' Bembry
Damion Lee
Derrick Jones Jr.
Damyean Dotson
John Konchar
Nate Hinton
Torrey Craig
Taj Gibson
Harrison Barnes
De'Andre Hunter
Jordan Nwora
Precious Achiuwa
Alec Burks
RJ Barrett
Jarrett Allen
Donte DiVincenzo
Kevin Porter Jr.
Maurice Harkless
Timothe Luwawu-Cabarrot
Dorian Finney-Smith
Naji Marshall
Pat Connaughton
Gary Trent Jr.
Giannis Antetokounmpo
Jaren Jackson Jr.
Tony Snell
Serge Ibaka
Richaun Holmes
Bruce Brown
Kyle Anderson
Pascal Siakam
Justin Patton
Nemanja Bjelica
Daniel Gafford
Will Magnay
Ben McLemore
Elfrid Payton
Ryan Arcidiacono
Ty-Shon Alexander
Tre Jones
Cassius Winston
Chris Chiozza
Nick Richards
Terence Davis
Jaylen Nowell
Taurean Prince
Cody Zeller
Kelly Olynyk
Ben Simmons
Domantas Sabonis
Harry Giles III
Jontay Porter
Danilo Gallinari
Kendrick Nunn
Nico Mannion
Grant Riller
Brandon Goodwin
Rodions Kurucs
Mamadi Diakite
Dean Wade
Frank Ntilikina
Keljin Blevins
Mason Jones
Devin Booker
Luke Kennard
Miye Oni
Paul Watson
Chandler Hutchison
Kenrich Williams
Cameron Payne
D.J. Wilson
Al-Farouq Aminu
Paul George
T.J. Warren
Joe Ingles
Justin Jackson
Tim Hardaway Jr.
Caleb Martin
Cody Martin
Shake Milton
Mikal Bridges
Juan Toscano-Anderson
Alfonzo McKinnie
Kevin Knox II
Duncan Robinson
Patrick Williams
Saddiq Bey
Tyler Bey
Grayson Allen
Kentavious Caldwell-Pope
Chimezie Metu
JaKarr Sampson
Willie Cauley-Stein
Frank Kaminsky
Ivica Zubac
Lauri Markkanen
Mitchell Robinson
James Wiseman
Marcus Morris Sr.
Cam Reddish
E'Twaun Moore
Marvin Bagley III
Goran Dragic
Ricky Rubio
CJ McCollum
Jahmi'us Ramsey
Immanuel Quickley
Karim Mane
Edmond Sumner
Luke Kornet
Hamidou Diallo
Rajon Rondo
Patrick Beverley
Patty Mills
Raul Neto
Quinn Cook
Trae Young
Terrence Ross
Jakob Poeltl
Alize Johnson
Luka Samanic
Kent Bazemore
Matisse Thybulle
Seth Curry
Chasson Randle
Devon Dotson
Cole Anthony
Kevon Looney
Reggie Bullock
Caris LeVert
PJ Dozier
Nickeil Alexander-Walker
Chris Paul
Ish Smith
Trevor Ariza
Brandon Clarke
KZ Okpala
Jordan Clarkson
Jordan Poole
Zach LaVine
Josh Richardson
Devin Vassell
Josh Green
Davis Bertans
Dario Saric
Tomas Satoransky
Axel Toupane
Amir Coffey
Killian Tillie
Obi Toppin
D'Angelo Russell
Monte Morris
Saben Lee
Robert Covington
Jonathan Isaac
Tyler Johnson
Moses Brown
Ed Davis
Stephen Curry
De'Aaron Fox
Lou Williams
Mike Conley
Malachi Flynn
Kyle Kuzma
Derrick White
Jerome Robinson
Landry Shamet
Adam Mokoka
Matt Thomas
CJ Elleby
Nate Darling
Mychal Mulder
Jerami Grant
Greg Whittington
Jayson Tatum
Cameron Johnson
Mo Bamba
Garrett Temple
Coby White
Tyler Herro
Ty Jerome
Killian Hayes
Jalen Harris
Evan Fournier
Svi Mykhailiuk
Jake Layman
Yuta Watanabe
George Hill
Rodney Hood
Darius Bazley
Juancho Hernangomez
Jarred Vanderbilt
Michael Porter Jr.
Kelly Oubre Jr.
Josh Jackson
Malik Beasley
Anfernee Simons
Dylan Windler
Furkan Korkmaz
Alex Caruso
Avery Bradley
Wes Iwundu
Jarrett Culver
Sean McDermott
Alen Smailagic
Jalen Smith
Kira Lewis Jr.
Deni Avdija
Paul Reed
Christian Wood
Michael Carter-Williams
Cassius Stanley
Nerlens Noel
Jaxson Hayes
Kristaps Porzingis
Kyle Guy
Andrew Wiggins
Lonzo Ball
Brian Bowen II
Wenyen Gabriel
Jalen McDaniels
Dejounte Murray
Nicolas Claxton
Ja Morant
Delon Wright
Tyrese Haliburton
Brodric Thomas
Otto Porter Jr.
Dennis Schroder
Chris Boucher
Kevin Huerter
Justin James
Theo Maledon
R.J. Hampton
Jeremy Lamb
Bol Bol
Kostas Antetokounmpo
Will Barton
Brandon Ingram
Deividas Sirvydis
Justin Holiday
Shai Gilgeous-Alexander
LaMelo Ball
Tyrell Terry
Patrick McCaw
Josh Hall
Isaiah Joe
Isaac Bonga
Jaden McDaniels
Aleksej Pokusevski
484 rows in set (0.00 sec)

ORDER BY 搭配 LIMIT¶

結合 ORDER BY 與 LIMIT，就可以進行「前 m 高」或「前 m 低」的資料分析¶

-- 「前 m 低」的資料分析
SELECT column_names
  FROM table_name
 ORDER BY column_names
 LIMIT m;

-- 「前 m 高」的資料分析
SELECT column_names
  FROM table_name
 ORDER BY column_names DESC
 LIMIT m;
In [11]:
SELECT *
  FROM movies
 ORDER BY release_year
 LIMIT 10;
Out[11]:
id title release_year rating director runtime
99 The Kid 1921 8.3 Charles Chaplin 68
195 Sherlock Jr. 1924 8.2 Buster Keaton 45
153 The Gold Rush 1925 8.2 Charles Chaplin 95
199 The General 1926 8.1 Clyde Bruckman 67
116 Metropolis 1927 8.3 Fritz Lang 153
225 The Passion of Joan of Arc 1928 8.1 Carl Theodor Dreyer 114
43 City Lights 1931 8.5 Charles Chaplin 87
94 M 1931 8.3 Fritz Lang 99
245 It Happened One Night 1934 8.1 Frank Capra 105
39 Modern Times 1936 8.5 Charles Chaplin 87
10 rows in set (0.00 sec)
In [12]:
SELECT *
  FROM movies
 ORDER BY release_year DESC
 LIMIT 10;
Out[12]:
id title release_year rating director runtime
167 Zack Snyder's Justice League 2021 8.3 Zack Snyder 242
59 Hamilton 2020 8.5 Thomas Kail 160
231 Soul 2020 8.1 Pete Docter 100
30 Parasite 2019 8.6 Bong Joon Ho 132
62 Joker 2019 8.4 Todd Phillips 122
76 Avengers: Endgame 2019 8.4 Anthony Russo 181
108 1917 2019 8.3 Sam Mendes 119
165 Klaus 2019 8.2 Sergio Pablos 96
201 Ford v Ferrari 2019 8.1 James Mangold 152
244 Portrait of a Lady on Fire 2019 8.1 Céline Sciamma 122
10 rows in set (0.00 sec)

重點統整¶

  • 加入 ORDER BY 能夠以指定變數的大小來排序查詢結果。
  • 排序可以採取預設的「遞增」或者指定「遞減」方式。
  • 可以指定多個變數搭配各自的排序方式。
  • 可以使用衍生計算欄位進行排序。
  • 結合 ORDER BY 與 LIMIT 來進行「前 m 高」或「前 m 低」的資料分析。
/*
截至目前學起來的 SQL 有哪些？
SQL 寫作順序必須遵從標準 SQL 的規定。
*/
SELECT column_names     -- 選擇哪些欄位
  FROM table_name       -- 從哪個資料庫的資料表
 ORDER BY column_names  -- 指定依照哪個變數排序
 LIMIT m;               -- 查詢結果顯示前 m 列就好