Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> help with group by
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
![]() |
![]() |