Documentation Index Fetch the complete documentation index at: https://docs.omniql.com/llms.txt
Use this file to discover all available pages before exploring further.
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 ASCMySQL SELECT * FROM users ORDER BY name ASCMongoDB 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 DESCMongoDB 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 DESCMongoDB 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 DESCMySQL 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) DESCMongoDB 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 ASCMongoDB 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 10MongoDB db.users.find({}).sort({ created_at: -1 }).limit(10)
: GET User ORDER BY id ASC LIMIT 20 OFFSET 40
Database Output PostgreSQL SELECT * FROM users ORDER BY id ASC LIMIT 20 OFFSET 40MongoDB 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
Next Steps
Joins Combine multiple tables
Grouping Aggregate with GROUP BY
