Greater than a value

From: "Fontenot, Paul" <Paul(dot)Fontenot(at)bannerhealth(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Greater than a value
Date: 2003-06-26 21:24:36
Message-ID: 230BCAB977308F43BD851AFAE55A86416B1C1E@phx01018.bannerhealth.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2003-06-26 21:27:20 Re: Fw: Removing foreign key and adding sequence
Previous Message Chad Thompson 2003-06-26 21:19:19 Re: Fw: Removing foreign key and adding sequence