Wednesday, October 29, 2008

Select top and last five record from Database

In Query try this:

FOR TOP 5
select top 5 * from table

//-------------------

FOR LAST 5
select top 5 * from table order by primarykey_columnname desc

Good Luck

No comments: