2015년 1월 3일 토요일

Fusion Table SQL Syntax

I am trying to return data in a select statement where I need to do a sub query to return a maximum value. I know the syntax that will accomplish this in a SQL server db but its not translating to a fusion I'd.  Below is what I'm trying to do. Any suggestions would be appreciated.

Select ROWID, User, Status from fusion table id alias where ROWID = ( Select Maximum(ROWID) from table id where user = user.alias))

If there is a simpler way I really just want all users from table with newest status.



subqueries are not possible
you have to do the queries in 2 steps


댓글 없음:

댓글 쓰기