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 <vik....@gmail.com> 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 > google-appengine-j...@googlegroups.com. > To unsubscribe from this group, send email to > google-appengine-java+unsubscr...@googlegroups.com<google-appengine-java%2bunsubscr...@googlegroups.com> > . > 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 google-appengine-j...@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.