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?

Reply via email to