Filtering a bunch of records to one after a selection has returned a bunch of them

From: jfc100(at)btopenworld(dot)com (Joe)
To: pgsql-general(at)postgresql(dot)org
Subject: Filtering a bunch of records to one after a selection has returned a bunch of them
Date: 2001-12-27 15:01:16
Message-ID: 88d9f4b3.0112270701.4a3741d@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am trying to establish whether or not it is possible - and how to
implement the solution - to execute an sql statement and restricting
the results to a single match even though there may be more than a
single record which matches the criteria.

e.g. select min(counter) from my_table butonlyone;

Cheers
Joe

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Eckermann 2001-12-27 16:46:18 Re: simple query question
Previous Message Ben-Nes Michael 2001-12-27 14:35:25 persistent connection using PHP and Transaction