Find the lastName in SQL table

I have one table where I want to find out the last name from full Name. For Example-

Ramesh Kumar Singh

Mahesh Pratam Thakur

Dheeraj Mani Tripathi

Our answer should be following in the result-

Singh

Thakur

Tripathi

  Devbrat Tripathi

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any