Greater than a value
От | Fontenot, Paul |
---|---|
Тема | Greater than a value |
Дата | |
Msg-id | 230BCAB977308F43BD851AFAE55A86416B1C1E@phx01018.bannerhealth.com обсуждение исходный текст |
Ответы |
Re: Greater than a value
|
Список | pgsql-novice |
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.
В списке pgsql-novice по дате отправления: