Re: A SQL Question About distinct, limit, group by, having,

From: Ragnar Hafstað <gnari(at)simnet(dot)is>
To: Lin Kun Hsin <s9154083(at)cyut(dot)edu(dot)tw>
Cc: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: A SQL Question About distinct, limit, group by, having,
Date: 2005-03-31 08:05:24
Message-ID: 1112256324.3038.1.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Dinesh Pandey 2005-03-31 11:05:16 Help - Oracle 9i to PostgreSQL SQL conversion
Previous Message Richard Huxton 2005-03-31 07:15:17 Re: save me from an unconstrained join