Re: Aggregate Function to return most common value for a column

From: Benjamin Smith <ben(at)schoolpathways(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Aggregate Function to return most common value for a column
Date: 2009-05-23 01:47:03
Message-ID: 200905221847.03423.ben@schoolpathways.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've used this same concept in subqueries for a very long time. Doing this
allows me to "dive in" and get other values from the joined table, rather than
just the thing that we're getting the most of.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
"I kept looking for somebody to solve the problem.
Then I realized... I am somebody!"

-- Author Unknown

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Murray Richardson 2009-05-23 01:55:00 performance tuning on Vista problem
Previous Message Craig Ringer 2009-05-23 00:55:54 Re: quoting values magic