Postgres Pro
Downloads
Home   >   mailing lists

Useful SQL-statement? - Mailing list pgsql-sql

From anssiman@jippii.fi (-anssi)
Subject Useful SQL-statement?
Date
Msg-id e88fd790.0309230134.14b56ec2@posting.google.com
Whole thread Raw
Responses Re: Useful SQL-statement?  (Bruno Wolff III <bruno@wolff.to>)
Re: Useful SQL-statement?  (Tomasz Myrta <jasiek@klaster.net>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Ivar"
Date:
Subject: Re: Compatible datatype of image in SQL server
Next
From: Bruno Wolff III
Date:
Subject: Re: Useful SQL-statement?