Instead of getting these values with query best option is to store this values when you add new employee.So create one more dataset with fields city, area and employeecount.whenever you add new employee update the count .then you can get the count with simple query select employeecount from <newdataset> where city==<city> && area==<area>
On Sat, Jun 12, 2010 at 8:05 PM, Vik <[email protected]> wrote: > Hie > > I have following data set: > > City, Area emp-name > > and have to write a query which shows number of employees by city and area. > So data should display like: > > Delhi rohini 5 > Delhi nehru 10 > Hyd madhapur 6 > Hyd hitech 24 > Cheanni park 20 > > > So what the query should be? Please advise > > Thankx and Regards > > Vik > Founder > www.sakshum.com > www.sakshum.blogspot.com > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine for Java" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]<google-appengine-java%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-appengine-java?hl=en. > -- Regards, Ravinder Singh Maan -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
