| Author: Altaf Hussain 20 Jun 2007 | Member Level: Gold | Rating:  Points: 2 |
Hi
If you have a column in which u save the date and time, then base ont the date and time u can retrieve the last five records ,
|
| Author: Gopakumar 20 Jun 2007 | Member Level: Gold | Rating: Points: 2 |
if u are using any autoincrement field or any id field then
select top 5% from tablename order by idfield desc
|
| Author: rameshgoudd 20 Jun 2007 | Member Level: Gold | Rating: Points: 2 |
Hi,
wat ever the records u wil enter,those wil be inserted in the database in a sequence manner...
so use the query to get top 5
ie select top5(id) from tablename orderby id desc.
Ramesh
|
| Author: Victor Fernandez 06 Sep 2007 | Member Level: Silver | Rating: Points: 2 |
Hi,
Select Top 1 * from TableName Order By UniqueID DESC
Regards
Victor
|