"Reinhard Max" wrote... > > 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?
Darn it! I keep forgetting about ORDER BY. Yep, that is exactly what I wanted. Thanks. jos?