Received: from ncc1701.cistron.net (ncc1701.cistron.net [195.64.68.38]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3QJrY323445; Thu, 26 Apr 2001 15:53:34 -0400 (EDT) (envelope-from news@uucp.cistron.nl) Received: from news by ncc1701.cistron.net with local (Exim 3.20 #1 (Debian)) id 14srpU-0004sb-00; Thu, 26 Apr 2001 21:53:32 +0200 From: jdassen@cistron.nl (J.H.M. Dassen (Ray)) Subject: Re: random rows Date: Thu, 26 Apr 2001 19:53:32 +0000 (UTC) Organization: Cistron Internet Services B.V. Lines: 15 Message-ID: References: <3AE85E1E.2D39D02D@agliodbs.com> X-Trace: ncc1701.cistron.net 988314812 11873 195.64.65.236 (26 Apr 2001 19:53:32 GMT) X-Complaints-To: abuse@cistron.nl To: pgsql-admin@postgresql.org, pgsql-sql@postgresql.org Errors-To: <> X-Archive-Number: 200104/156 X-Sequence-Number: 1296 Jie Liang wrote: >e.g. what my selectee is a set of 1000 rows, I want randomly pickup 100 of >1000. Have you tried SELECT * FROM selectee ORDER BY random() LIMIT 100; ?o HTH, Ray -- JHM, jij bent echt nerd :)) maar wel een goeie :) Soort van programmerende furby Gezien op #cistron