If you database supports the RANK() over syntax select * from ( select b,e,f,a, rank() over B order by date(a) desc as therank from [YourTablenameHere] ) as innersql where therank=1 If your database doesn't have a rank function you could try something like select t1.A,t1.B,t1.E,t1.F from sometable as t1 inner join ( select a,max (B) as b from sometable ) as t2 on t1.A=t2.A and t1.B = t1.B
On Tuesday, 22 May 2012 21:17:14 UTC+1, Gabe wrote: > Thanks. > > I'll stick with doing the grouping in js. I was hoping I could just punch > in a query and be off, but I should still be able to make it work with a > little effort. > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/IqRcjWsiaqsJ. 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.
