Sorting

Order results using the ORDER BY clause.

Basic Syntax

:GET Entity ORDER BY field
:GET Entity ORDER BY field ASC
:GET Entity ORDER BY field DESC

Ascending Order (Default)

:GET User ORDER BY name
:GET User ORDER BY name ASC

Database	Output
PostgreSQL	`SELECT * FROM users ORDER BY name ASC`
MySQL	`SELECT * FROM users ORDER BY name ASC`
MongoDB	`db.users.find({}).sort({ name: 1 })`

Descending Order

:GET User ORDER BY created_at DESC

Database	Output
PostgreSQL	`SELECT * FROM users ORDER BY created_at DESC`
MongoDB	`db.users.find({}).sort({ created_at: -1 })`

Multiple Columns

:GET User ORDER BY status ASC, created_at DESC

Database	Output
PostgreSQL	`SELECT * FROM users ORDER BY status ASC, created_at DESC`
MongoDB	`db.users.find({}).sort({ status: 1, created_at: -1 })`

Expressions in ORDER BY

Sort by calculated values or function results.

:GET Product ORDER BY price * quantity DESC
:GET User ORDER BY UPPER(name) ASC

Database	Output
PostgreSQL	`SELECT * FROM products ORDER BY price * quantity DESC`
MySQL	`SELECT * FROM products ORDER BY price * quantity DESC`

Function in ORDER BY

:GET User ORDER BY LENGTH(name) DESC

Database	Output
PostgreSQL	`SELECT * FROM users ORDER BY LENGTH(name) DESC`
MongoDB	`db.users.aggregate([{ $addFields: { nameLen: { $strLenCP: '$name' } } }, { $sort: { nameLen: -1 } }])`

With WHERE Clause

:GET User WHERE active = true ORDER BY name ASC

Database	Output
PostgreSQL	`SELECT * FROM users WHERE active = true ORDER BY name ASC`
MongoDB	`db.users.find({ active: true }).sort({ name: 1 })`

With LIMIT

:GET User ORDER BY created_at DESC LIMIT 10

Database	Output
PostgreSQL	`SELECT * FROM users ORDER BY created_at DESC LIMIT 10`
MongoDB	`db.users.find({}).sort({ created_at: -1 }).limit(10)`

Pagination Pattern

:GET User ORDER BY id ASC LIMIT 20 OFFSET 40

Database	Output
PostgreSQL	`SELECT * FROM users ORDER BY id ASC LIMIT 20 OFFSET 40`
MongoDB	`db.users.find({}).sort({ id: 1 }).skip(40).limit(20)`

Complete Example

:GET id, name, email, created_at FROM User 
  WHERE status = "active" 
  AND role IN ("user", "premium")
  ORDER BY created_at DESC, name ASC 
  LIMIT 25 
  OFFSET 50

Getting Started

Queries

Mutations

Schema

Control

Reference

Databases

Integration

Basic Syntax

Ascending Order (Default)

Descending Order

Multiple Columns

Expressions in ORDER BY

Function in ORDER BY

With WHERE Clause

With LIMIT

Complete Example

Next Steps

Joins

Grouping

​Basic Syntax

​Ascending Order (Default)

​Descending Order

​Multiple Columns

​Expressions in ORDER BY

​Function in ORDER BY

​With WHERE Clause

​With LIMIT

​Pagination Pattern

​Complete Example

​Next Steps

Joins

Grouping

Basic Syntax

Ascending Order (Default)

Descending Order

Multiple Columns

Expressions in ORDER BY

Function in ORDER BY

With WHERE Clause

With LIMIT

Pagination Pattern

Complete Example

Next Steps