Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Samir H.
  Where is Samir H.?
 Yogyakarta
 Indonesia
 Samir H.
 To: Michel Levy
  Where is Michel Levy?
 
 France
 Michel Levy
 Tags
Subject: RE: enginbehaviour
Thread ID: 288699 Message ID: 288965 # Views: 23 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Projects and Design
Date: Monday, December 27, 2010 12:05:40 PM         
   


> >
> >
> >
> > Why must we use aggregation? Can you explain?
> >
select religion,city from employees order by religion,city group by religion,city

> > Would I have to use a aggregate function for the query above? Even if I don't need it?
> > (Note: above is just a query from top of my head, as a example)
> >
> >
> >
> >
> >
> >
> >
> > Regards
> > Samir
>
> --
> Hi Samir,
>
> in your example, what is the meaning of the GROUP BY? what do you want to show in each group?
>
>
> Michel L

I don't know, that's why I wrote the note at the bottom of the message :-U. I have actually no example, but I thought I had such GROUP BY queries in my code, that don't have a aggregate function (but I'm not sure, I must re-check my code).
I must study the group by clause again, it is not always very clear in my mind...

Regards
Samir

ENTIRE THREAD

enginbehaviour Posted by vaishali maske @ 12/23/2010 10:09:04 AM
RE: enginbehaviour Posted by Cetin Basoz @ 12/23/2010 10:17:23 AM
RE: enginbehaviour Posted by vaishali maske @ 12/23/2010 10:59:06 AM
RE: enginbehaviour Posted by Anders Altberg @ 12/23/2010 2:56:09 PM
RE: enginbehaviour Posted by Rakesh Kumar @ 12/23/2010 3:39:27 PM
RE: enginbehaviour Posted by Anders Altberg @ 12/24/2010 2:23:32 AM
RE: enginbehaviour Posted by Rakesh Kumar @ 12/25/2010 1:03:31 PM
RE: enginbehaviour Posted by Samir H. @ 12/27/2010 10:19:44 AM
RE: enginbehaviour Posted by Michel Levy @ 12/27/2010 11:34:50 AM
RE: enginbehaviour Posted by Samir H. @ 12/27/2010 12:05:40 PM
RE: enginbehaviour Posted by Michel Levy @ 12/27/2010 12:55:39 PM
RE: enginbehaviour Posted by Cetin Basoz @ 12/27/2010 11:37:58 AM
RE: enginbehaviour Posted by Anders Altberg @ 12/27/2010 12:22:00 PM
RE: enginbehaviour Posted by Anders Altberg @ 12/27/2010 12:24:24 PM
RE: enginbehaviour Posted by Samir H. @ 12/27/2010 1:08:41 PM