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
