Answers for "order by count postgresql"

order by count postgres

select 
    count(w.id) as mycount,
    w.company_id,
    c.company_name,
    c.city
from 
    companies c 
    left join workers w on 
        c.id=w.company_id 
group by 
    w.company_id,
    c.company_name,
    c.city
order by mycount desc;

Posted by: Guest on April-27-2021

Source

Code answers related to "order by count postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

Answers for "order by count postgresql"

Code answers related to "order by count postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "order by count postgresql"

Code answers related to "order by count postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us