Originally posted by Andyr6381
Does anyone know what query to use to return the 2 largest numbers in a row called ID?
I.e I want to return the 2 latest additions to the database, identified by the ID row,
Regards
Andy
Select * from table order by row limit 2
if you need the other end of the list, use
select * from table order by row desc limit 2
