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


> >
> > --
> > 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

--
Anders explains what I wanted to show you: very often, one says GROUP BY when thinking DISTINCT.

Michel L

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