Try this one: select * from (select * from multiturnTable order by rowid desc limit 5000) where (player1 = ? or player2 = ?) and (complete=0 or p1SubmitScore=0 or p2SubmitScore=0)
Pavel On Mon, Mar 14, 2011 at 1:58 PM, Ian Hardingham <i...@omroth.com> wrote: > Ah, sorry about this - my query is this one: > > SELECT * FROM multiturnTable WHERE rowid in (SELECT rowid FROM > multiturnTable WHERE player1 ='?' UNION ALL SELECT rowid FROM > multiturnTable WHERE player2 = '?') AND (complete=0 OR p1SubmitScore=0 > OR p2SubmitScore=0) > > And I only want to consider the last 5000 for any SELECTs from > multiturnTable. > > Thanks, > Ian > > On 14/03/2011 17:54, Adam DeVita wrote: >> select id from table order by id desc limit 5000 >> >> >> Adam >> >> On Mon, Mar 14, 2011 at 1:52 PM, Ian Hardingham <i...@omroth.com >> <mailto:i...@omroth.com>> wrote: >> >> Hey guys. >> >> I have a table with an autoincrement primary ID, and as part of a >> select >> I would like to only take the 5000 "largest"/most recent ids. Is >> there >> a quick way of doing this without having to get the max first? >> >> Thanks, >> Ian >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org <mailto:sqlite-users@sqlite.org> >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> >> >> >> -- >> VerifEye Technologies Inc. >> 905-948-0015x245 >> 151 Whitehall Dr, Unit 2 >> Markham ON, L3R 9T1 >> Canada >> > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users