On 18 October 2010 00:33, Tim Uckun <timuc...@gmail.com> 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. >
That is a bit problematic because it necessitates knowing the number of rows total, and slow counting is an idiosyncrasy of postgres. http://wiki.postgresql.org/wiki/Slow_Counting To get the top 10%: SELECT * FROM table LIMIT(SELECT (COUNT(*) * 0.1)::integer FROM table) -- Regards, Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
