may be this link help you http://zetcode.com/databases/sqlitetutorial/
On Wed, May 16, 2012 at 2:41 PM, Kostya Vasilyev <[email protected]> wrote: > 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 > -- Dr.M -- 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
