Many thanks! Ismo's reply solved the problem, and Tom's reply solved
another one.
Marko
Ismo Tuononen wrote:
> select studentid,max(score) from studentprofile group by studentid;
On 20/02/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> The optimal index for this would be on studentprofile(studentid,score).