Get Recent records from the table

Submit Blog |

Blogs Home |

Ads

Here is a small code snippet for getting the recent records from the table.

drop table VENKAT_TABLE
go
create table Venkat_Table(code varchar(100),rate decimal(10,8),date1 date)
go
insert into VENKAT_TABLE values ('sam', 1.240000, '01/08/2004')
insert into VENKAT_TABLE values ('sam', 1.840000, '02/08/2004')
insert into VENKAT_TABLE values ('pal', 1.240000, '01/08/2005')
insert into VENKAT_TABLE values ('pal', 0.840000, '10/08/2003')

select code,rate,date1 from
(
select ROW_NUMBER() over (partition by code order by date1) as rank1,*
from VENKAT_TABLE ) t
where rank1=1

Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTech

Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTech
http://kaashivinfotech.com/Ebooks.aspx

Found interesting? Add this to:

| More | Bookmark It

More Blogs from Jvprabhusanthi

More ...

About Venkatesan Jayakantham

Experience:	9 year(s)
Home page:	http://www.dotnetfunda.com
Member since:	Tuesday, May 01, 2012
Level:	Starter
Status:	[Member]
Biography:

>> Write Response - Respond to this post and get points

More Blogs
	Time dimesions in SSAS Dotnet 4.0 Chart issue Toggle key issue in Windows Vista Exception from HRESULT: 0x800AC472 Unable to invoke a class in C# To check file exists or not in c# Update Query with Inner join in SQL Server Fetch a pattern of data in SQL Server Microsoft.AnalysisServices.AdomdClient issue Submit Blog \| More ...