how to select the last three value in database

gowthaman8870226416

Declare @t table(name varchar(100))



Insert Into @t 



select 'abhijit' union all select 'debasis' union all select 'mangoli' union all select 'hobita' union all



select 'jansu' union all select 'uday' union all select 'santunu' union all select 'sachin' union all



select 'jeeva' union all select 'sashi'







Select Top 3 Name From(



					Select 



						Rn = ROW_NUMBER() Over(Order by(Select 1) )



						,Name



					From @t



				)x



Order By x.Rn desc

Name



sashi



jeeva



sachin

Best Regards,
Niladri Biswas