X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D17E9475EE2 for ; Tue, 13 May 2003 17:32:59 -0400 (EDT) Received: from hotmail.com (f82.law12.hotmail.com [64.4.19.82]) by postgresql.org (Postfix) with ESMTP id 39BD8475AA9 for ; Tue, 13 May 2003 17:32:56 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 13 May 2003 14:32:58 -0700 Received: from 207.34.65.240 by lw12fd.law12.hotmail.msn.com with HTTP; Tue, 13 May 2003 21:32:57 GMT X-Originating-IP: [207.34.65.240] X-Originating-Email: [daniel_katka@hotmail.com] From: "Katka a Daniel Dunajsky" To: pgsql-sql@postgresql.org Subject: Postgresql and Top N Analysis? Date: Tue, 13 May 2003 15:32:57 -0600 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 13 May 2003 21:32:58.0116 (UTC) FILETIME=[38DB5440:01C31997] X-Spam-Status: No, hits=-1.6 required=5.0 tests=BAYES_30 version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/251 X-Sequence-Number: 13416 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. Daniel _________________________________________________________________ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963