Re: help with group by

Have you tried ;
select lname || ',' || fname as fullname,count(children) from people
group by lname || ',' || fname;

I beleive the Oracle documentation states that you must use the exact column definition... Received on Tue Jan 11 2005 - 19:05:23 CST