Search for last record and display contents

[Annemarie McKeown]

How do you search for the last record entered in your table. What query would I use to do this?
Many thanks.

[James Swan]

If you have a table with a nice auto-incrementing primary key column defined as an integer etc, you could issue:
select * from mytable
where myprimarykey = (select max(myprimarykey) from mytable)

[Annemarie McKeown]

Thanks James, worked out fine.