need some help with a SELECT - Mailing list pgsql-general

From Tony Grant
Subject need some help with a SELECT
Date
Msg-id 990453941.19360.11.camel@tonux
Whole thread Raw
In response to Re: Re: Which Front End for Postgresql  (Michelle Murrain <mpm@norwottuck.com>)
List pgsql-general
Monday...

I can't get my brain around this one.

Get the top three replies from a quizz.

I want to select from a table all records which have a value of
1.000000, 2.000000 and 3.000000. Then I want to class the records by the
column which has the most 1 followed by the most 2...

Yes I was thrown out of math class in high school... All these dark
secrets which are coming out now...

I don't want code I want the logic so that I can try to write the code
for myself. TIA

Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html


pgsql-general by date:

Previous
From: Zak McGregor
Date:
Subject: Re: Queries across multiple databases  (was: SELECT from a table in another database).
Next
From: Frank Bax
Date:
Subject: psql shell problem