Order by

To order the results, use the filter or all method with the order_by parameter.

PythonSQL Result

User.all(order_by="age")

SELECT * FROM user ORDER BY age;

To order the results in descending order, use the - sign before the field name.

PythonSQL Result

User.all(order_by="-age")

SELECT * FROM user ORDER BY age DESC;

You can also order by multiple fields and mix them with filters.

PythonSQL Result

User.filter(name="John", order_by=["age", "-name"])

SELECT * FROM user WHERE name = 'John' ORDER BY age, name DESC;