hi can you post same sample data for us?. so that we can give the query easily.
2009/4/9 Andy <p7ere...@gmail.com> > > Hi, > > I have a table with a WORD column, a RANK column, and a PAGE_ID > column. I want to make a select query that combines several word > literals with AND, groups by PAGE_ID, and sums the RANK in each group, > sorting by highest sum of RANK. How do I do this, my guess is a > subquery? > > Andy > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---