Home

7: Sorting Records

The Basics of Sorting

-- Ascending
SELECT *
FROM products
ORDER BY price;

-- Descending
SELECT *
FROM products
ORDER BY price DESC;

Two Variations on Sorting

We can also sort by alphabetical order.

-- Sort in alphabetical order
SELECT *
FROM products
ORDER BY name;

You can also order by multiple different properties in order of declaration.

SELECT *
FROM products
ORDER BY price, weight;

Offset and Limit

  • OFFSET skips the first N records.
  • LIMIT only give first N records of a result.
SELECT *
FROM products
ORDER BY price, weight
OFFSET 2
LIMIT 3;

Repository

https://github.com/okeeffed/developer-notes-nextjs/content/postgresql/SQL-And-PostgreSQL-The-Complete-Developers-Guide/7-Sorting-Records

Sections

The Basics of Sorting
Two Variations on Sorting
Offset and Limit

Related

1-Simple-But-Powerful-SQL-Statements
10-Selecting-Distinct-Records
11-Utility-Operators-Keywords-And-Functions
13-PostgreSQL-Complex-Datatypes
14-Database-Side-Validation-And-Constraints
15-Database-Structure-Design-Patterns
16-Building-A-Like-System
17-Building-A-Mention-System
2-Filtering-Records
22-Understanding-The-Internals-Of-PostgreSQL
23-Indexes-For-Performance
24-Basic-Query-Tuning
25-Advanced-Query-Tuning
26-Common-Table-Expressions
27-Recursive-Common-Table-Expressions
28-Simplifying-Queries-With-Views
29-Optimizing-Queries-With-Materialized-Views
3-Working-With-Tables
30-Handling-Concurrency-And-Reversibility-With-Transactions
31-Managing-Database-Design-With-Schema-Migrations
32-Schema-Vs-Data-Migrations
34-Data-Access-Patterns-Repositories
35-Security-Around-PostgreSQL
36-Fast-Parallel-Testing
4-Relating-Records-With-Joins
5-Aggregation-Of-Records
6-Working-With-Large-Datasets
7-Sorting-Records
8-Unions-And-Intersections-With-Sets
9-Assembling-Queries-With-Subqueries
SQL-And-PostgreSQL-The-Complete-Developers-Guide