[sqlite] Sorting by greatest count amount

[Reinhard Max]

On Thu, 6 Aug 2015 at 17:41, jose isaias cabrera wrote:

> SELECT pmuk, count(*) FROM LSOpenJobs WHERE pmuk LIKE '% %' GROUP BY pmuk;

For ordered results you need an ORDER BY clause, and if you want to 
order by a calculated column (count in this case), you have to give it 
a name:

SELECT pmuk, count(*) AS amount
FROM LSOpenJobs
WHERE pmuk LIKE '% %' 
GROUP BY pmuk
ORDER BY amount

Does this do what you want?

cu
        Reinhard