random rows

From: Jie Liang <jliang(at)ipinc(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: sqllist <pgsql-sql(at)postgresql(dot)org>
Subject: random rows
Date: 2001-04-26 18:38:21
Message-ID: Pine.BSF.4.10.10104261133340.77756-100000@tidal.ipinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-sql


How I can return random N rows from my select stmt?
like:
e.g. what my selectee is a set of 1000 rows, I want randomly
pickup 100 of 1000.

thanks.

Jie LIANG

St. Bernard Software

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang(at)ipinc(dot)com
www.stbernard.com
www.ipinc.com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message benoit.le-dizes@voila.fr 2001-04-26 19:00:49 logs
Previous Message Ing. Roberto Andrade Fonseca 2001-04-26 18:12:14 Re: random rows

Browse pgsql-general by date

  From Date Subject
Next Message Joel Burton 2001-04-26 18:45:53 Re: help with serial type
Previous Message solo 2001-04-26 18:25:15 Problem connecting to postgres

Browse pgsql-sql by date

  From Date Subject
Next Message Joel Burton 2001-04-26 19:18:29 Re: random rows
Previous Message Ing. Roberto Andrade Fonseca 2001-04-26 18:12:14 Re: random rows