Group results by date

Hi,

Should be a newbie one...

I have the result of a query that I'd like to have grouped by the date, but it does not, see image for details.

The two select statements return the exact same thing.

tnx
~j
delete.png
LVL 2
prositAsked:
Who is Participating?
 
Shaun KlineLead Software EngineerCommented:
Your group by includes the fields in your aggregate functions. Try removing them.
0
 
prositAuthor Commented:
oh cr@p of course, the sums make it work...

I had originally not sum'd the values up, then added them after grouping everything... so dumb :)

tnx
~j
0
 
Scott PletcherSenior DBACommented:
Yep; change your G B to just:

GROUP BY fcdate
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.