Hi, I don't think you can do it using only the query language. We are planning to add both join and group-by on the client side api somewhere in the near future, which will solve your problem.
In the mean time, an ugly work around could be to send the query twice, once with grouping and once without grouping, and copy the date from the un-grouped table. I am not sure that this is the best solution for you, however. I hope this helps. Cheers, VizWiz On Wed, Aug 19, 2009 at 12:06 PM, rokur <[email protected]>wrote: > > Hi, > > I've managed to extract individual high scores from a spreadsheet with > Date (A), Name (B) and Score (C), using this query: > > http://spreadsheets.google.com/tq?tqx=out:html&tq=select B,max(C) > group by B order by max(C) desc label max(C) "High > Score"&key=tjrDO76DjoJ-NDIiPJaD84g > > But how can I now add the date (column A) to this result set, as > additional info, rather than part of the query? > > If I just add A to the select string ("select A,B,max(C)"), I'm forced > to add A to the group by also, and then get to many groupings. > > I guess I need some nested select or join, but cannot figure out to do > this with this Query Language. > > Yours sincerely > > Rókur > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Visualization API" 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-visualization-api?hl=en -~----------~----~----~----~------~----~------~--~---
