Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 29050 invoked from network); 9 Apr 2008 06:46:53 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 9 Apr 2008 06:46:53 -0000 Received: (qmail 66314 invoked by uid 500); 9 Apr 2008 06:46:53 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 66287 invoked by uid 500); 9 Apr 2008 06:46:53 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 66276 invoked by uid 99); 9 Apr 2008 06:46:53 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Apr 2008 23:46:53 -0700 X-ASF-Spam-Status: No, hits=-1.0 required=10.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [192.18.6.24] (HELO gmp-eb-inf-2.sun.com) (192.18.6.24) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Apr 2008 06:46:09 +0000 Received: from fe-emea-09.sun.com (gmp-eb-lb-2-fe2.eu.sun.com [192.18.6.11]) by gmp-eb-inf-2.sun.com (8.13.7+Sun/8.12.9) with ESMTP id m396kAPJ013317 for ; Wed, 9 Apr 2008 06:46:20 GMT Received: from conversion-daemon.fe-emea-09.sun.com by fe-emea-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0JZ100L01PBYCD00@fe-emea-09.sun.com> (original mail from Oystein.Grovlen@Sun.COM) for derby-user@db.apache.org; Wed, 09 Apr 2008 07:46:10 +0100 (BST) Received: from [129.159.112.249] by fe-emea-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0JZ10049APFVFZE0@fe-emea-09.sun.com> for derby-user@db.apache.org; Wed, 09 Apr 2008 07:45:32 +0100 (BST) Date: Wed, 09 Apr 2008 08:45:31 +0200 From: =?ISO-8859-1?Q?=D8ystein_Gr=F8vlen?= Subject: Re: limit, offset and random In-reply-to: <16578551.post@talk.nabble.com> Sender: Oystein.Grovlen@Sun.COM To: Derby Discussion Message-id: <47FC660B.90900@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 8BIT References: <16547686.post@talk.nabble.com> <16578551.post@talk.nabble.com> User-Agent: Thunderbird 2.0.0.12 (X11/20080228) X-Virus-Checked: Checked by ClamAV on apache.org unludo wrote: > OK thanks a lot for your answers. > > Regarding the 'ORDER BY RANDOM()', you also plan to have something similar? ORDER BY RANDOM() already works for me. Example: ij> select i from t where i < 5; I ----------- 1 2 3 4 4 rows selected ij> select i from t where i < 5 order by random(); I ----------- 1 2 4 3 4 rows selected ij> -- �ystein