Hello, I have this table where I store player results for each week: # select * from pref_money limit 5; id | money | yw ----------------+-------+--------- OK32378280203 | -27 | 2010-44 OK274037315447 | -56 | 2010-44 OK19644992852 | 8 | 2010-44 OK21807961329 | 114 | 2010-44 FB1845091917 | 774 | 2010-44 (5 rows) I'm trying to find the winners for each week and also how many times the player has won, so that I can display a number of medals at his or her profile page. I'm trying: # select id, money from pref_money where money in (select max(money) from pref_money group by yw); id | money ----------------+------- DE8048 | 3927 VK91770810 | 6133 DE7115 | 6655 OK252342810632 | 8053 OK228530000997 | 1013 (5 rows) But I'm worried that "where in" will return false positives (for the cases with the same money values) and also I don't know how to count the repeated winners? Thank you Alex -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general