Main content
Course: Unlisted resources area > Unit 2
Lesson 3: SQL documentation- SQL: CREATE table with multiple data types
- SQL: CREATE table with a primary key
- SQL: Specifying DEFAULT values in CREATE TABLE
- SQL: CREATE TABLE with foreign key reference
- SQL: INSERTing values in tables
- SQL: SELECTing rows
- SQL: SELECTing with WHERE conditions
- SQL: Filter with IN
- SQL: SELECT with ORDER BY
- SQL: Transform SELECT results with CASE
- SQL: Filtering with LIKE
- SQL: Using SELECT with LIMIT
- SQL: ROUND and other core functions
- SQL: SELECT with aggregate functions
- SQL: Grouping SELECT results with GROUP BY
- SQL: Using HAVING with GROUP BY
- SQL: JOIN on tables
- SQL: UPDATE and DELETE
- SQL: ALTER TABLE
© 2024 Khan AcademyTerms of usePrivacy PolicyCookie Notice
SQL: SELECT with ORDER BY
When you issue a
SELECT
, the rows often get returned in the same order they were inserted in the table. You can change the order of the rows by adding an ORDER BY
clause at the end of your query, with a column name after.By default, the ordering will be in ascending order, from lowest value to highest value. To change that to descending order, specify
DESC
after the column name. To be explicit that it's in ascending order, specify ASC
.You can specify multiple column names after
ORDER BY
if you want to sort by one column and then the other(s), in order.▶️ You can also learn about this in our Querying the table talkthrough.