how to find last three value in table

using BETWEEN and findout

gowthaman8870226416

Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

Try this

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

--Result

Name

sashi

jeeva

sachin

Best Regards,
Niladri Biswas

Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

CREATE TABLE [dbo].[sample2](
[s_id] [int] IDENTITY(1,1) NOT NULL,
[s_Name] [varchar](10) NULL,
[s_Price] [int] NULL,
[s_product] [varchar](29) NULL,
PRIMARY KEY CLUSTERED
(
[s_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


SELECT TOP 3 * FROM sample2 ORDER by s_id DESC

Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

select top 3 * from books order by bid desc

Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

select top 3 * from Table_Name order by Column_Name desc

ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://www.aspnetcodes.com/

Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator

Select Top3 * From Table_Name Order by   Column_Name desc

Venky.Net, if this helps please login to Mark As Answer. | Alert Moderator