hi, all, I have a table in postgresql which have 2 columns like this: a|b ------ X A X A Y A D B H B E B D B P C when I do select and order by, I got this: a | b ---+--- X | A X | A Y | A D | B H | B | B D | B P | C I want to get the only 2 rows(limit or random) if the column "b" have the same value. so, the result of the above is a | b ---+--- X | A X | A D | B H | B P | C how to do that, thanks all! -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
