Search results

Hi Does anyone know sql enough to lend me a hand. I just want to know how I can simply locate the last record in a table and the move that record into a new table. I've been trying for a couple of weeks now and no success. Thanks in advance.