On Fri, Sep 18, 2009 at 07:54:30PM -0400, Martin Gainty wrote: > > //Display the top 40 % of rows in BB_DEPARTMENT > > SQL> select ROWNUM,ID FROM EMPLOYEES WHERE ROWNUM < .3*(SELECT COUNT(ID) FROM > BB > _DEPARTMENT) GROUP BY ROWNUM,ID; > > ROWNUM > ---------- > 1 > HTH > Martin Gainty
That's Oracle, not PostgreSQL. Are you really trying to help here? Cheers, David. -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
