sort by highest number postgres code example
Example: sort by highest number postgres
postgres=# select deptno,max(sal) from emp group by deptno order by max(sal);
deptno | max
--------+---------
30 | 2850.00
20 | 3000.00
10 | 5000.00
(3 rows)