Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> help with group by

help with group by

From: Randy Harris <randy_at_SpamFree.com>
Date: Wed, 12 Jan 2005 00:45:12 GMT
Message-ID: <sq_Ed.13978$by5.4207@newssvr19.news.prodigy.com>


Is there a way to include a column concatenation and an aggregate in the same query?

This doesn't work:

select lname || ',' || fname as fullname, count(children)
from people
group by fullname Received on Tue Jan 11 2005 - 18:45:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US