Follow the link and get "some answer", http://groups.google.co.in/group/Oracle-PLSQL/browse_thread/thread/e61e2f8cd05c2f67/f31a6b9068ee5f08?lnk=gst&q=Concatenating+rows+in+Oracle+SQL#f31a6b9068ee5f08
Alternatively, search this group for "Concatenating rows in Oracle"......... and by the way, You must right "the query" yourself. Also, check the point raised by Mike..... Regards, Sonty On Apr 10, 2:27 am, Michael Moore <michaeljmo...@gmail.com> wrote: > 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- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---