getting the current value of an auto-incrementing ID
I have a table with an with a key column with the name id declared as an auto-number so that it automatically increments when I insert a record to the table.
What Select statement can I run to determine what the current (last) value of id is?