On Mon, Oct 18, 2010 at 12:53 PM, Darren Duncan <darren@xxxxxxxxxxxxxxxx> wrote: > Tim Uckun wrote: >> >> Is there a way to select the top 10% of the values from a column? >> >> For example the top 10% best selling items where number of sales is a >> column. > > The top 10% would be a variable number of records. ÂIs that what you want, > or would you rather, say, just see the top N items? Yes this is what I want. I don't care how many records I pull up (well I might want to put a LIMIT on them). I want the top 10% -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
