troubleshooting Question

Group By function in Oracle

Avatar of Flex Tron
Flex TronFlag for United States of America asked on
Oracle Database
4 Comments2 Solutions99 ViewsLast Modified:
Hi Team,
I am trying to use a simple Group by code as shown, ...But don't need to do a Group BY on ISIN..(Varchar)...But when I remove that...I get error saying not a Groupby function...Can I just do a group by based on first two columns. ?


select distinct G.CLIENT_ID,G.YEARMONTH, D.ISIN,SUM(G.ACCOUNT_CBV) as ACCOUNT_CBV, SUM(G.TOTAL_REVENUES) as TOTAL_REVENUES from GMIS G, DEPOT D 
where G.CLIENT_ID = D.CLIENT_ID 
GROUP BY G.CLIENT_ID,G.YEARMONTH,D.ISIN order by Client_ID;
ASKER CERTIFIED SOLUTION
Haris Dulic
Just an IT guy :)

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros