how to find last three value in table

using BETWEEN and findout

gowthaman8870226416

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

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

select top 3 * from books order by bid desc

WITH employeeCTE AS

(

  SELECT *,ROW_NUMBER()OVER(ORDER BY empid DESC) AS rowno FROM employee1

)



SELECT TOP 3  empid,empname FROM employeeCTE ORDER BY rowno

Table script

CREATE TABLE [dbo].[employee1](

    [empid] [int] IDENTITY(1,1) NOT NULL,

    [empname] [varchar](100) NULL,

PRIMARY KEY CLUSTERED

(

    [empid] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

Insert Script

GO

SET ANSI_PADDING OFF

GO

SET IDENTITY_INSERT [dbo].[employee1] ON

INSERT [dbo].[employee1] ([empid], [empname]) VALUES (1, N'Pandian')

INSERT [dbo].[employee1] ([empid], [empname]) VALUES (2, N'Mani')

INSERT [dbo].[employee1] ([empid], [empname]) VALUES (3, N'Raj')

INSERT [dbo].[employee1] ([empid], [empname]) VALUES (4, N'Kv')

INSERT [dbo].[employee1] ([empid], [empname]) VALUES (5, N'Naveen')

SET IDENTITY_INSERT [dbo].[employee1] OFF

select top 3 * from Table_Name order by Column_Name desc

ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://sandeep-chourasia.blogspot.com/

@Perfect.Chourasia@Gmail.Com
Question is to find-out the last 3 inserted value. Please check my answer.

please mark it as answer....That helps other who search the same...

Select Top3 * From Table_Name Order by   Column_Name desc