On Tue, Sep 23, 2008 at 3:57 PM, Richard Broersma <richard.broersma@xxxxxxxxx> wrote: > SELECT A."dimension_book"."call", SUM( B."dimension_book"."call" ) AS > OrderedRowNbr > FROM ( your_above_query_without_the_limits ) AS A > INNER JOIN ( your_above_query_without_the_limits ) AS B > ON A."dimension_book"."call" >= B."dimension_book"."call" > ORDER BY A."dimension_book"."call" > HAVING SUM( A."dimension_book"."call" ) % 10 = 0; Oops I just noticed that I used sum() where count() should be used and that I forgot to include the group by clause. Other than that, I hope the suggestion was at least halfway helpful. -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug
