X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 19108475EE2 for ; Tue, 13 May 2003 17:36:11 -0400 (EDT) Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11]) by postgresql.org (Postfix) with ESMTP id 55B86475AA9 for ; Tue, 13 May 2003 17:36:10 -0400 (EDT) Received: from lerlaptop.iadfw.net (lerlaptop.iadfw.net [206.66.13.21]) (authenticated bits=0) by lerami.lerctr.org (8.12.9/8.12.9/20030225) with ESMTP id h4DLa7KK004071; Tue, 13 May 2003 16:36:08 -0500 (CDT) Date: Tue, 13 May 2003 16:36:07 -0500 From: Larry Rosenman To: Katka a Daniel Dunajsky , pgsql-sql@postgresql.org Subject: Re: Postgresql and Top N Analysis? Message-ID: <372780000.1052861767@lerlaptop.iadfw.net> In-Reply-To: References: X-Mailer: Mulberry/3.0.3 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: by amavisd-milter (http://amavis.org/) X-Spam-Status: No, hits=-25.2 required=5.0 tests=BAYES_10,IN_REP_TO,QUOTED_EMAIL_TEXT,REFERENCES, REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/252 X-Sequence-Number: 13417 --On Tuesday, May 13, 2003 15:32:57 -0600 Katka a Daniel Dunajsky wrote: > Hello all, > > Can anyone give me an hit how to do Top 'N' Analysis in postgresql (if it > is possible)? I see that postgresql does not have an pseudocolumn rownum, > therefore I can't use query like this: > > SELECT * > FROM (SELECT DISTINCT session_type_id FROM user_sessions ORDER BY > session_type_id) as dummy GROUP BY dummy; > > Thank you for your time. look at the LIMIT parameter of SELECT, If I'm reading you right. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749