SQL

If ID column is Unique ID then you can get last inserted id using @@IDENTITY.

yes id is unique

how?

This question has been asked a number of times on EE.

https://www.experts-exchange.com/questions/21469141/Get-last-inserted-record.html
https://www.experts-exchange.com/questions/24146012/get-identity-of-last-inserted-id-with-out-using-mssql-built-in-functions.html

just after the insert statement, you can use SELECT SCOPE_IDENTITY()

if not, you will have to use: select max(ID) from table

actually, @@identity is only to be used when
1) you are using SQL 7
2) you are in the same session that the one that did that "last insert"

for sql 2000 and later, you shall use SCOPE_IDENTITY() , but 2) above still applies.

so:

INSERT INTO yourtable ( col1, col2... ) VALUES ( 1,2, ... )
SELECT * FROM yourtable WHERE ID_col = @@identity -- sql 7
SELECT * FROM yourtable WHERE ID_col = SCOPE_IDENTITY() -- sql 2000+

note: while the function @@identity still exists in sql 2000+, it does though refer to the last identity value generated, which might not be the table you inserted into, but generated by a insert that is run by a trigger on the table you inserted to ...

to conclude: if you want to get the last generated record, even if the application did not do the insert itself:

select * from yourtable where id_col = ( Select max(id_col) from yourtable )
or
select top 1 * from yourtable order by id_col desc

hope this clarifies