Postgres Pro
Downloads
Home   >   mailing lists

Re: A SQL Question About distinct, limit, group by, having, - Mailing list pgsql-sql

From Ragnar Hafstað
Subject Re: A SQL Question About distinct, limit, group by, having,
Date
Msg-id 1112256324.3038.1.camel@localhost.localdomain
Whole thread Raw
In response to Re: A SQL Question About distinct, limit, group by, having, aggregate  ("Lin Kun Hsin" <s9154083@cyut.edu.tw>)
List pgsql-sql
Tree view 
On Thu, 2005-03-31 at 13:14 +0800, Lin Kun Hsin wrote:
> below is the sql schema. i hope it will help. 
> 
> i want the top 3 score students in every class

this has been discussed before. a quick google gives me:
http://archives.postgresql.org/pgsql-sql/2004-04/msg00067.php


gnari

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: save me from an unconstrained join
Next
From: "Dinesh Pandey"
Date:
Subject: Help - Oracle 9i to PostgreSQL SQL conversion