examples please? also, RANK is a reserved word, you should not name a column 'RANK'. Mike
On Wed, Apr 8, 2009 at 2:04 PM, Andy <p7ere...@gmail.com> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
