Django QuerySet Order By

Django QuerySet Order By

Order By

To sort QuerySets, Django uses the order_by() method:

Example

Order the the result alphabetically by firstname:

Run Example »

In SQL, the above statement would be written like this:


Descending Order

By default, the result is sorted ascending (the lowest value first), to change the direction to descending (the highest value first), use the minus sign (NOT), - in front of the field name:

Example

Order the the result firstname descending:

Run Example »

In SQL, the above statement would be written like this:


Multiple Order Bys

To order by more than one field, separate the fieldnames with a comma in the order_by() method:

Example

Order the the result first by lastname ascending, then descending on id:

Run Example »

In SQL, the above statement would be written like this:

ArmenianEnglish