I have the following query:
select count(*),msg_text from msg_table where msg_text like '%PIX-1%'
group by msg_text order by count desc;
And I qould like to be able to do something like:
select count(*),msg_text from msg_table where msg_text like '%PIX-1%'
COUNT => '50' group by msg_text order by count desc;
Is that possible in PostgreSQL?
***PRIVILEGED & CONFIDENTIAL***
Unless expressly stated otherwise, this message (and any attachment(s)
thereto) is confidential and may be privileged. It is intended for the
addressee(s) only. If you are not an addressee, any disclosure or
copying of the contents of this e-mail or any action taken (or not
taken) in reliance on it is strictly prohibited. If you are not an
addressee, please inform sender immediately and delete this message from
your system.