The query you posted uses Microsoft SQL Server extensions. You can read about them on MSDN.
Since Android does not use MS SQL as its database, you need to find a way to implement the same logic without these extensions. Understanding the logic is the first step. Reading the MSSQL docs on the extensions will aid in completing this step. -- K 2012/5/16 David Hodeffi <[email protected]> > i cannot get what do you mean when you say that? > and i dont know what the result of this query. > > my main idea of this query is to get the last round from each game. > how can i do that? > > On May 7, 1:55 am, lbendlin <[email protected]> wrote: > > how about using max(dateUpdated) instead? > > > > > > > > > > > > > > > > On Sunday, May 6, 2012 7:56:20 AM UTC-4, David Hodeffi wrote: > > > > > i have this DB: > > > > > USERS > > > > > userId int PK, > > > userName nvarchar(50) > > > > > GAMES > > > > > gameId int PK, > > > dateCreated datetime > > > > > ROUNDS > > > > > roundId int Pk, > > > gameId int (FK to GAMES), > > > dateCreated datetime, > > > dateUpdated datetime > > > > > ROUNDDETAILS > > > > > roundId int, > > > userId int, > > > point int, > > > primary key(roundId ,userId) > > > > > my problem is that in sqlite i cannot execute this query (cause ther > > > is no support for "raw_number() over(...)": > > > > > select > > > AllRound.roundId RoundId, > > > AllRound.gameId, > > > RD.userId, > > > U.userName, > > > RD.point > > > from > > > (select > > > R.roundId, > > > R.gameId, > > > dateUpdated, > > > row_number() over(partition by gameId order by dateUpdated > > > desc) Rid > > > from GAMES g join ROUNDS R on G.gameId=R.gameId) AllRound > > > join ROUNDDETAILS RD on R.roundId=RD.roundId and points > > > join USERS U on RD.userId=U.userId > > > where AllRound.Rid=1 > > > > > if you familar with sql, so this query returns all the last round of > > > each game > > > > > any suggestions? > > > > > thanks in advance, David! > > -- > You received this message because you are subscribed to the Google > Groups "Android Developers" 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/android-developers?hl=en > -- You received this message because you are subscribed to the Google Groups "Android Developers" 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/android-developers?hl=en
