Return-Path: Delivered-To: apmail-incubator-empire-db-user-archive@minotaur.apache.org Received: (qmail 68251 invoked from network); 22 Jan 2010 13:18:31 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 22 Jan 2010 13:18:31 -0000 Received: (qmail 71362 invoked by uid 500); 22 Jan 2010 13:18:31 -0000 Delivered-To: apmail-incubator-empire-db-user-archive@incubator.apache.org Received: (qmail 71321 invoked by uid 500); 22 Jan 2010 13:18:30 -0000 Mailing-List: contact empire-db-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: empire-db-user@incubator.apache.org Delivered-To: mailing list empire-db-user@incubator.apache.org Received: (qmail 71312 invoked by uid 99); 22 Jan 2010 13:18:30 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 22 Jan 2010 13:18:30 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of francisdb@gmail.com designates 209.85.220.228 as permitted sender) Received: from [209.85.220.228] (HELO mail-fx0-f228.google.com) (209.85.220.228) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 22 Jan 2010 13:18:21 +0000 Received: by fxm28 with SMTP id 28so453134fxm.20 for ; Fri, 22 Jan 2010 05:18:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :from:date:message-id:subject:to:cc:content-type; bh=QNaoweYnXGFKSPadCDU05ZxjW5uR76DP5skt/wk0NRA=; b=V5D018vNHhUvcH1j6hA3gMBknEcMlSrqalezbrwywdR3PSgpfum3ZU/FOaLGzFsxIa NrvRf8DknW7/U5EYDXPzkhchKQkuwuiwmHiFzBNMFFjnB/2I0A0MGkDTLCqkqBlrJy49 xJjSPa4FtRtr521eNZVm9R2BgnF40Ztr10/jo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; b=of1uJmIiK8YmJ6HwaTDFuI7y/WBius+WED17544qHWNf618KtifpOcQTbe5xTJtpeH CGglFtusu9XmAZ9vzVSt5x3K93aRejTJJDlp2KW7uHnMR2j4YlLEfdVPCoO0RLGMiqgH T7ylA7SzLRhfplmCeGrNpIXcehOaigBpOIxyM= MIME-Version: 1.0 Received: by 10.239.186.199 with SMTP id i7mr341561hbh.44.1264166280167; Fri, 22 Jan 2010 05:18:00 -0800 (PST) In-Reply-To: <3ab983231001220502w5216f23bhed7a9920dafe1264@mail.gmail.com> References: <6B2310525158A94688EA80986F6EF20B715D18CE93@EXCH-MLV-01.tebabank.msft> <8f5974891001190636ob900ea4u6e5c3ffdd475536b@mail.gmail.com> <6B2310525158A94688EA80986F6EF20B715D18CE9A@EXCH-MLV-01.tebabank.msft> <6B2310525158A94688EA80986F6EF20B715D18CE9C@EXCH-MLV-01.tebabank.msft> <3ab983231001220502w5216f23bhed7a9920dafe1264@mail.gmail.com> From: Francis De Brabandere Date: Fri, 22 Jan 2010 14:17:40 +0100 Message-ID: <3ab983231001220517u1f946e69v44281f2dd7da2d42@mail.gmail.com> Subject: Re: Rowlimits: OFFSET and LIMIT To: empire-db-user@incubator.apache.org Cc: Martijn Dashorst Content-Type: text/plain; charset=ISO-8859-1 Jaco, could you create a wiki user account on: http://cwiki.apache.org/confluence/display/empiredb/ so that I can add you McKinley, you should have write access now I think. But I am not sure if we should ask you to first sign a ICLA (http://www.apache.org/licenses/) Martijn, could you help us out here? Cheers, Francis On Fri, Jan 22, 2010 at 2:02 PM, Francis De Brabandere wrote: > I'll ask on the infra list how we can give RW access > > On Fri, Jan 22, 2010 at 11:34 AM, McKinley wrote: >> Thanks for reporting back. Did you use DESC in your ORDER BY? If you >> don't have wiki access you might consider posting the wiki markup in >> the issue tracker. I registered for the wiki, but didn't now get >> access by default. >> >> I'll be testing ROW_NUMBER on SQL Server tomorrow and will let you >> know what I find. >> >> Thanks, >> >> McKinley >> >> On Fri, Jan 22, 2010 at 10:21 AM, Jaco van Tonder wrote: >>> Rainer, >>> >>> Thanks for this info. This works well for Oracle. I would like to document this on the wiki for future reference until a proper limit/offset implementation can be implemented. >>> >>> ---Jaco >>> >> > > > > -- > http://www.somatik.be > Microsoft gives you windows, Linux gives you the whole house. > -- http://www.somatik.be Microsoft gives you windows, Linux gives you the whole house.