need some help with a SELECT

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