https://stackoverflow.com › questions › 1402682

If you don't want the count result to be returned (because of an ORM framework or so), you could apply it directly in the order by clause: select c.* from companies c left join workers w on c.id = w.company_id group by c.id order by count(w.id) desc;

https://collectingwisdom.com › postgresql-order-by-count

How to Order by Count in PostgreSQL (With Example) Often in PostgreSQL you may want to order the rows of a table based on the count of values in a particular column. You can use the following syntax to do so: SELECT team, COUNT(team) FROM athletes. GROUP BY team. ORDER BY COUNT(team);

https://stackoverflow.com › questions › 1403456

SELECT (SELECT count(*) FROM workers w WHERE w.company_id=c.id AND w.country='USA') AS mycount, c.id, c.company_name FROM companies c ORDER BY mycount DESC

https://www.slingacademy.com › article › postgresql-order-by-ascending-and-descending-sorting

In PostgreSQL, sorting query results is primarily done using the ORDER BY clause. Sorting can be either ascending (ASC) or descending (DESC). SELECT column1 FROM table_name ORDER BY column1 ASC; This code snippet selects all values from column1 and sorts them in ascending order. To sort in descending order:

https://www.postgresql.org › docs › current › queries-order.html

The ORDER BY clause specifies the sort order: SELECT select_list . FROM table_expression . ORDER BY sort_expression1 [ASC | DESC] [NULLS { FIRST | LAST }] [, sort_expression2 [ASC | DESC] [NULLS { FIRST | LAST }] ...] The sort expression (s) can be any expression that would be valid in the query's select list. An example is:

https://www.postgresql.fr › docs › current › queries-order.html

La clause ORDER BY spécifie l'ordre de tri : SELECT liste_selection FROM expression_table ORDER BY expression_tri1 [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [ , expression_tri2 [ ASC | DESC ] [ NULLS { FIRST | LAST } ] ...

https://learnsql.com › cookbook › how-to-order-by-count-in-sql

The ORDER BY clause then sorts the groups according to that computation. As usual, you can use both ascending or descending order with ORDER BY . If you want descending order (as in this example), you use the DESC keyword.

https://www.w3schools.com › postgresql › postgresql_orderby.php

The ORDER BY keyword is used to sort the result in ascending or descending order. The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword.

https://runebook.dev › fr › docs › postgresql › queries-order

Un ordre de sortie particulier ne peut être garanti que si l'étape de tri est explicitement choisie. La clause ORDER BY spécifie l'ordre de tri : SELECT select_list. FROM table_expression. ORDER BY sort_expression1 [ASC | DESC] [NULLS { FIRST | LAST }] [, sort_expression2 [ASC | DESC] [NULLS { FIRST | LAST }] ...]