Find a newly inserted record from table without using MAX or TOP

i have a table employee and i want to find the newly inserted record from employee table without using MAX And TOP ...it possible ? yes then How?

Quote:

Originally Posted by Ripendra007

i have a table employee and i want to find the newly inserted record from employee table without using MAX And TOP ...it possible ? yes then How?

i'm assuming you're using an identity column as the primary key on your table. if so you can say:

SELECT @.@.IDENTITY

your development environment might also provide this information in a more seamless way