How to get last inserted value of a Specific column in SQL?

Is there any way where we could us IDENT_CURRENT() to retrieve a specific value from a specific column