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 <[email protected]> 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 <[email protected] >> <mailto:[email protected]>> 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 >> [email protected] <mailto:[email protected]> >> 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
