Re: [PERFORM] Top n queries and GROUP BY

Rich Cullingford wrote: All, This is a straight SQL question, maybe not appropriate for a performance list, but... I have a simple stock holdings setup: => select * from t1; nam |co | num -+---+-- joe | ibm | 600 abe | ibm | 1500 joe | cisco | 1

[PERFORM] Top n queries and GROUP BY

7;t figure out a correlated subquery (or GROUP BY arrangement or anything else) that will cycle through the names. I vaguely remember that these kinds or queries are hard to do in standard SQL, but I was hoping that PG, with its extensions... Thanks, Rich Cullingford

[PERFORM] Java Out-of-memory errors on attempts to read tables with millionsof rows

available that modify this behavior? Are there commercial implementations of PG JDBC that don't have this problem? (Shame on me, but I have to ask. :) Any help will be greatly appreciated! Rich Cullingford [