Useful SQL-statement?

From: anssiman(at)jippii(dot)fi (-anssi)
To: pgsql-sql(at)postgresql(dot)org
Subject: Useful SQL-statement?
Date: 2003-09-23 09:34:26
Message-ID: e88fd790.0309230134.14b56ec2@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello!

Is there any standard SQL-statement, which produce
resultset containing best plyers of the each team?

player |team|points
-------------------
paul col 10
peter col 12
steve det 12
sergei det 8
jere dal 4

Resultset:

peter
steve
jere

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tomasz Myrta 2003-09-23 11:41:00 pl/pgsql, cursors and C function
Previous Message Oleg Bartunov 2003-09-23 05:38:48 Re: GiST and full text search