Re: selecting a random record

From: Alexey Borzov <borz_off(at)rdw(dot)ru>
To: Culley Harrelson <culleyharrelson(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: selecting a random record
Date: 2001-02-07 10:12:19
Message-ID: 1496914841.20010207131219@rdw.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings, Culley!

At 06.02.2001, 13:11, you wrote:

CH> Any suggestions on how to select a random record from
CH> any given table?
SELECT * FROM any_given_table ORDER BY random() LIMIT 1;

--
Yours, Alexey V. Borzov, Webmaster of RDW

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexey Borzov 2001-02-07 10:15:47 Re[2]: Re: new type proposal
Previous Message Rainer Mager 2001-02-07 10:03:10 Problem with JDBC transactions