Greetings. I have this query,
SELECT pmuk, count(*) FROM LSOpenJobs WHERE pmuk LIKE '% %' GROUP BY pmuk; this works but it is not sorted. I tried things like SELECT pmuk, count(*) FROM LSOpenJobs WHERE pmuk LIKE '% %' GROUP BY count(*) || '-' || pmuk; and SELECT pmuk, count(*) FROM LSOpenJobs WHERE pmuk LIKE '% %' GROUP BY '' || count(*) || '' || '-' || pmuk; I would like to have the pmuk sorted by the lowest to highest, if possible. Otherwise, the opposite. Thanks. jos?