As per your question, i have the written the following query.

Hope it helps.

Create table latest_value

(

[name] varchar(50)

)

go

Insert into latest_value

Select 'Avinash'

Union All

Select 'Suresh'

Union All

select 'Rahul'

Union All

Select 'Anil'

Union All

Select 'Zayed'

Union All

Select...