From: Katka a Daniel Dunajsky <daniel_katka@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Postgresql and Top N Analysis?
Date: Tue, 13 May 2003 15:32:57 -0600
Message-ID: <Law12-F82jsKcWYSQxg00019507@hotmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: daniel_katka@hotmail.com
Subject: Re: Postgresql and Top N Analysis?
In-Reply-To: <Law12-F82jsKcWYSQxg00019507@hotmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox